Ratio in Pivot Table

[ismailsari]

Hello,

In the Pivot Table, as shown in the table below, I would like to calculate two different ratios.

One is the ratio of the totals obtained directly from the Qlik tool within themselves, and the other is the ratio of the row total within itself.

Is it possible for me to set up this structure?

[rwunderlich]

In your General Total Avg expression, use the TOTAL keyword to indicate you want the denominator to be the total for all rows. Like this:

Sum([General Total]) / Sum(TOTAL [General Total])

-Rob