Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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.
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
Thanks Andrew.
This was really helped me a lot.