Subtotals choice Pivot Table

[jaymerry]

Hello,

I need to select on which columns (axis) I need to see Subtotals in a Pivot Table.

Can we activate / desactivate subtotals for a Pivot Table with a button ?

Do you think that this kind of functionnality is possible ?

Thank you for your help,

Regards,

Jaymerry

[Miguel_Angel_Baeyens]

Hello Jaymerry,

If you mean you want to see subtotals from some of your expressions but not all of them, use the Dimensionality() function:

If(Dimensionality() = 0, Sum(Value), '')

Hope that helps.

[jaymerry]

Hello Miguel,

Thanks for your answer.

No, what I need is to select on which dimensions subtotals appear.

Thanks for your hep,

Best regards,

Jaymerry

[jaymerry]

Hello all,

Any ideas to manage subtotals with macros ?

Thanks for your help,

Jaymerry

[Miguel_Angel_Baeyens · Accepted solution]

Hello Jaymerry,

Check this post. You will likely need to check the API Guide.qvw file in your QlikView folder\Documentation for further options.

Hope that helps.

[jaymerry]

Thanks for your help Miguel.

Best Regards,

Jaymerry