Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI ,
I have 2 sets of data I am trying to cross reference to get a sum..i.e.
Data Set 1
Branch Ref Range Name = 'A' branches and 'B' Branches etc.
Branch Number Range Defintion = (4,5,6) and (1,3,8) etc.
Data Set 2
Branch Number = 1,2,3,4,5 etc.
Min Stock Level (multiple item values per branch) =10, 25, 15, 4, 2 etc.
I am trying to do a chart which has the Branch Ref Range Name & then the sum of the min stock levels based on this range i.e.
Branch Ref Range Name Sum Of Min Stock Levels
'A' Branches 76
'B' Branches 42
etc.
I have tried Branch Ref Range Name as a dimension & then
sum( {$<BRANCH Number={Branch Number Range Defintion}>} MIN_LEVEL ) as an expression but this just does not work
Does anyone have any ideas please (I attached an example file)
Any help greatly appreciated
Thanks
Nick
Hi,
Then i feel some how you need to link those two tables and then you can use them for calculations.
Regards,
Kaushik Solanki