ASP (Avg Selling price) and pivot tables

[james]

All, i am trying to find out if i need to generate an ASP thorugh the script instead of the front end UI.

Long story short, if I have Qty and amount the pivot table in QLikview doesnt seem to sum up the 2 lines and the result is no Qty, and thus no ASP...

What i am trying to avoid is creating these calcucaltions in the script.. any ideas? The end result should look like

[#2]

Hi James,

Simply try the show partial sum option on the presentation tab. select the Material Dimension and check the show partial sum check box.

This will show the result you are looking for.

Thanks & Best Regards,

Kuldeep Tak

[pover]

If you aren't getting a total in a pivot table it is probably because you are not using a sum() or similar in the expression. In this case Quantity is a problem because it is not giving you a total either.

You shouldn't have to do this in the script.

Regards.