Subtotal inTable/Pivot

[#1]

Hi,

I need to calculate the subtotal for 1 specific variable sum(€) in table/or pivot.

In my example i want to do a report with bank and user and i need to calculate the subtotal for each bank.

I've found in the options the subtotal flag but qlik return the total off all data.

i add the example so it's easy to understand.

Can you help me?

Thank you

marco

[Miguel_Angel_Baeyens · Accepted solution]

Hello Marco,

Go to the chart properties, General tab and change the chart type to "Pivot Table". Then go to the Presentation tab, click on "User" dimension under "Dimensions and Expressions" and check "Show Partial Sums". Finally check "Always fully expanded".

Is that what you are expecting?

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[#3]

Great!

Thank you Miguel!

[#4]

Great!

Thank you Miguel!