Values are not summarizing after hiding the columns in list report

[kirru_alayam@yahoo.co.in]

Hi All,

In List report i have 5 dimensions and 1 fact column. In this report I am hiding columns based on user selection in prompt page.
If user does not enter any value, column should hide in the list report. this scenario i can able to solve and getting output also in list report. but the challenge is after hiding column facts are not summarizing.

Actual Output is

COLUMNS:            A    B    C  D    E   F   G
                             -----------------------------
                             A    B    C  D    E   F   10
                                                        FE  20

In this above scenario i created boolean variable and applied on column F to show and hide based  prompt F selection. after that i got perfect output. But when I hide column F getting below output. Column G is not summarizing.

COLUMNS:            A    B    C  D    E      G
                             -----------------------------
                             A    B    C  D    E      10
                                                            20


Quick response would be highly appreciated.

Thanks,
Kiran

[jasmine0619]

Hi Kiran,

Better minds will provide you with a more efficient solution but a quick way that comes to mind is have a conditional block and place multiple lists with the list of columns based on a variable.

Since you will only show one list based on the variable, it will always summarize since you don't have the unwanted column in list.

It would be nice if we had render variable on columns too. The Box type none set on Style variable does not do the trick.

Here is an example :

Block Variable ListChoice Text Variable A, B, C ,D

Block A List 1 columns 1,2,3,4

Block B List 2, Columns 1,2,4

Block C List 3, Columns 1,4

Good luck let us know how it went

Jasmine