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)

[Chanty4u]

create a pivot table and add   Global and region style as dimension 

exp: count(value)

[ashok1203]

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.

[ankur_abhishek]

Hi ,

PFA

[ashok1203]

Thanks Ankur,

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.

[ashok1203]

Guys, Any help on this requirement in front end. It is bit Urgent.

[Anil_Babu_Samineni]

As i know, You need to create Dim field with in the script as Island Table

Load * Inline [

Dim

1

2

];

And then you must use Dimension as

Pick('Group', Dim, Region)

Then, Same as Expression

[ashok1203]

Thanks Anil for response,

I didn't get your point, Can you please elaborate some more detail.

[Anil_Babu_Samineni]

I mean this?

Re: Customized Value List

[effinty2112]

Hi Ashokkumar,

          If you're restricted to a front end solution then maybe a container set up as grid with two straight tables?

Regards

Andrew