BKNewton29
New Member
- Joined
- Sep 17, 2010
- Messages
- 30
I'm working with some data Where I have a branch, clients in a branch and products with that client. I've managed to get the values in a pivot from measures at product level provided I filter on a client. A soon as clear the client filter all the values become incorrect. Ideally I want to summarise the data at branch level but can't currently get past the client grouping issue. An example of the code I've written is below
=SUMX(values(ProductGroup[Common Product Name]),
CALCULATE([Local Retained Income 1 Year Ago] - [Local Renewable Income (PM)]))
Branch level field is [Oracle RC], client level field is [Client Ref]. I also have a field that joins Common Product and Client called [ClientRef|CommonProd]
Any suggestions would be greatly appreciated
=SUMX(values(ProductGroup[Common Product Name]),
CALCULATE([Local Retained Income 1 Year Ago] - [Local Renewable Income (PM)]))
Branch level field is [Oracle RC], client level field is [Client Ref]. I also have a field that joins Common Product and Client called [ClientRef|CommonProd]
Any suggestions would be greatly appreciated
