I have 8 'segments', under each segment I have many 'stores' and under each store there are many 'assets'.
There is a dimesion work_order_ type from which I need to filter only types "PM" and "CM" and view work order count for these types.
Global Filter: Store, Month and Segment
My question is,
I need to calculate ratio of total work order count of PM/total work order count of CM for the store located. this is done.
I also have to calculate one more ratio which will have total work order count of PM/total work order count of CM for the segment the store is located in. Total value for all the stores in that particlar segment the store selected is located in.
something like given below,
Asset CM PM Store % Segment %
A 1 1 100 45
B 2 4 50 23
C 3 6 50 78
D 4 2 200 34
E 5 8 12
F 6 8 45
Store % will have the total work order `count of PM/total work order count of PM for that particular store selected
Segment % will have total work order `count of PM/total work order count of PM for that segment the store is located in.