Hi Matthias and Norbert,
It will be great help if you can attach the workbook in version 9.0 as I am not able to open it?
Thanks for sharing the workbook. I am still working on it as it did not give me expected results.
I would like to understand exactly what you are aiming for.
What i understand is the following
a. the sales of each Sub-category-year "combination" divided by the total sales (all Sub-category-year combinations) in the datasource
b. the sales of each Sub-category-year "combination" divided by the total sales of each Sub-category in the datasource
Hope to hear from you.