Create Super Tab Sub Tab in Pivot table

[eromiyasimon]

i want to group expression and dimension under a tab,

attached the screen shot for your reference

[Anonymous]

Hi eromiya,

To group the expression you can create a dimension with MTH, RQRT and MAT fields. then pivot this to column headers.

Regards!!!

[eromiyasimon]

could you please give some sample QVW

[Anonymous]

Of course, see this:

Regards!!

[eromiyasimon]

Hi Capella thanks for your reply, I find its helpful but  all fields present in my table are all calculated fields and its huge calculations,

due to this im unable to add in the edit script as group.

is there any other way to achieve this ??

[neelamsaroha157]

Take a look if this helps

[Anonymous]

Hi,

You can use calculated dimensions with aggr function.

Send some example of data.

Regards!

[Anil_Babu_Samineni]

Create Calculated Dimension

ValueList('A','B','C','D',....)

And then transpose to row level then see