Problem

[#1]

Is possible to generate above chart in below format using straight table

[Anonymous]

I'm understand u r requirement .. can u elaborate it clearly ?

If possible post sample data

[qlikoqlik]

Hi Shwetha

There is Lables for Totals in the pivot table

I can only work out on the selected value using the below expression

GetFieldSelections(Contract) & 'Total'

Thanks and regards

Padma

[#4]

IT WON'T WORK

[Anonymous]

Place some sample data here

will post the application(QVW)

[simondachstr]

Use the dimensionality() function in combination with Padma's expression.

[#7]

HOW

[#8]

PFA

[#9]

=if(Dimensionality()=1,GetFieldSelections([Sub category]))&'Total'

I used this exp but it won't work

[simondachstr]

Use Only() instead of GetFieldSelections

[#11]

I used this

=if(Dimensionality()=1,Only(business))&'Total'

but it won't work. see the attachment