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.
Output: (In a Single table)
Create a straight table with these dimensions:
and an expression
Sum(if (ValueList('Global','APAC','EMEA','LAC','NA')='Global', Aggr(sum(value),Style),
I don't have any field with Global, All the totals need to show as Label 'Global'.
All the totals i need to display in the top, if i have taken a pivot table it will shows the totals in every field data level. I need all those total information at Top and then detailed information as per the attached screenshot as output.
Is there any possibility to achieve in the front end only. Because we have some many reports created in front end based on these fields. So, if i follow this method i need to edit all the existing reports. Can you please help me to achieve this in UI.
As i know, You need to create Dim field with in the script as Island Table
Load * Inline [
And then you must use Dimension as
Pick('Group', Dim, Region)
Then, Same as Expression
I mean this?