conditional label for subtotal

[#1]

Hi All,

I have an application where I have a pivot table ,is it possible to put a conditional subtotal(ie..label names) for pivot table.

Thanks & Regards,

Reena Abraham

[srchilukoori]

you can write expressions in the labels fields for each individual dimension on the pivot tables.

[#3]

Hi,

I have tried that but it is only working with selections. Without Selection its showing only Total ,not evaluating the Expression.

Thanks,

Reena

[#4]

its only work on selection.

If you want to show without selection, write in the script like 'If(GetSelectedCount(currency)=0,'All',GetFieldSelections(currency))'

Hope you understand

[#5]

Hi,

I had given the expression on Presentation Tab, for labels for Total. Hope you have mean that. Then also its working with selections. else its showing as 'All' based on the expression.

I need to show without selections dynamic labels.

Thnkss...

[#6]

Can you share your app. then i will work on it for you

[srchilukoori]

You need to check the option "always one selected value" on the currency field.