topic Pivot Table Madness - Calculating Weighted Avg in QlikView

Pivot Table Madness - Calculating Weighted Avg

marc_wintjen — Mon, 19 Mar 2012 22:33:01 GMT

Hi - I'm in Pivot Table Madness right now. I'm trying to calculate a Weighted Avg by multipling two differnent % of Total Calculations. I can come up with the correct numbers but having issues displaying it as a Pivot or Straight Table because I don't want to show one of the dimensions that is used in the calcuation. I've attached an example - any assistance would be greatly appreciated!

Re: Pivot Table Madness - Calculating Weighted Avg

Tue, 20 Mar 2012 04:36:59 GMT

The following may help.

Re: Pivot Table Madness - Calculating Weighted Avg

marc_wintjen — Tue, 20 Mar 2012 14:57:31 GMT

Thanks for your assistance but unfortunately that didn't work. What's happening is that it's aggregating the Total Units at the Product Brand level vs. breaking out the totals by Customer. Once you aggregate the data by ProductBrand, the calculation does not match up. For example, Product1 = 2.85% vs. what it should calculate which is 3.01% because we actually need a sum of the rows in a Pivot table.

Is that possible to calcuate the Sum of the rows in a Pivot Table? Thanks!

Pivot Table Madness - Calculating Weighted Avg

marc_wintjen — Wed, 21 Mar 2012 14:51:35 GMT

Does anyone have another option - should I move that calculation to the Scripting side? Thanks!