Help with the Average

[#1]

Hi everyone.

I am trying to put the Average as a column (call it B) rather than a row in a pivot table. But the other expression (sales, volume) stay the same.

This is the table I have now:

If it is possible, I would like my table look like

Product	XXX		Average
Cement	sum(sales)	12600	2520
Cement	Sum(volume)	2106	421.2
Grand	sum(sales)	24500	4900

Right now, the dimension is "Product", all the rest are expressions. May be the final table can be achieved somehow?

Thank you very much for your help.

Roger.

[#2]

Hi DV.

Not at all. Please go ahead. It helps me too.  I would love to learn more about Synthetic Dimensions. If you don't mind, please let me know when you finish. I am looking forward to it.

Thanks again Deepak.

[#3]

Your blog http://qlikshare.com/ has lots of Qlikview stuff. I am sure I will find something useful. Thank you for sharing.

Regards.