How To Create This Report?

I need to create the following report:










Location (City)
YTD Sales Qty for item category code : X
% for Sales Qty YTD compared to Sales Qty YTD previous year
YTD Sales Amount for ALL item categories
% for Sales Amount YTD compared to Sales Amount YTD previous year

I have the following matrix showing the source (OLAP)







X
Y
Z

YTD
PYTD
PYTD
Current Time
YTD
PYTD

Quantity
Amount
Quantity
Amount
Quantity
Amount
Quantity
Amount
Quantity
Amount
Quantity
Amount

New York
12
1000
417
123958
1
100
200
2000
200
2000
2570
242690

Total
12
1000
417
123958
1
100
200
2000
200
2000
2570
242690


The X, Y, Z is the item category dimension. YTD, Current time etc. is a calculated time dimension. (YTD=year to date, PTYD = Previous year to date)

What I need to do is:
1. For the YTD quantity of X, reference the PYTD of X and calculate the % of these two.
2. Sum amount for the YTD amount of ALL (sum X, Y, Z).
3. Equals 1. but then for the YTD amount of all.

Can I do this within one matrix or table? I tried using filters on item category in columngroups but this can not produce a column showing X and a second showing ALL.

I also tried using tables with separate filters but then the row count was different and rows were not matching. Furthermore I didn't manage to reference sums from other tables in a calculation.

Any help would be appreciated!

Tom.