requirement on report with totals

[ashok1203]

Hi All,

I need to create a report with all the detailed information and totals information by using the given data. Can anyone please help me to achieve the Output.

Source:

Output: (In a Single table)

[ashok1203]

Thanks Andrew,

As of i now, i did the same thing and placed the reports in a container. But user wants to export the data into a single file.

[effinty2112 · Accepted solution]

Hi Ashokkumar,

Create a straight table with these dimensions:

=ValueList('Global','APAC','EMEA','LAC','NA')

Style

and an expression

Sum(if (ValueList('Global','APAC','EMEA','LAC','NA')='Global', Aggr(sum(value),Style),

if(Region =ValueList('Global','APAC','EMEA','LAC','NA'),value)))

gives:

Region	Style	Value
Global	1221	150
Global	3456	360
Global	1230	390
Global	1234	500
APAC	1230	80
APAC	1234	100
APAC	1221	110
EMEA	1221	40
EMEA	3456	110
EMEA	1234	200
LAC	1234	50
LAC	3456	130
LAC	1230	160
NA	3456	120
NA	1230	150
NA	1234	150

Regards

Andrew

[ashok1203]

Thanks Andrew.

This was really helped me a lot.