Table showing weighted averages in columns and rows?
Dear Gents,
Being very new to QlikView development, I am forced to ask for some help to solve a challenge. I hope and think it should not be very complicated; still, I am stuck...
I have sales of a product. The comes in different size categories. In my excel setup, I have the different sizes in the columns. Sales volumes of each size category (product) is available in a variable in my report. Achieved price is available as turnover (variable) divided by sales volume. Reference price is joined in by an Excel file, one value for each size category of the product. Finally, achieved price is calculated as achieved price minus reference price.
For each column (each size category) all these variable should be shown. On the far right column, there should be sums / weighted averages (using volumes as keys for averages).
Finally, there will be many customers, and the total sum of the columns, should be weighted averages (by volume again) in each column.
I have included an example file, showing how I used to do this in Excel (using a pivottable to present data from a dump from Business Objects).
I am unsure whether to use a simple table or pivot to achieve the layout and content I am after.
Very grateful for any advice / recipe to put me on track.
