1 of 1 people found this helpful
I opened your workbook and started going through the hierarchy of calculations
you are consistently neglecting to aggregate the measures in your formulas
for example if you write A/B what happens is for every record A is divided by B and when you bring that to the viz it is aggregated with sum - that will total all rhe individulal results at the revord level - (add up all the a/b's together)
the correct way is to write sum(A)/Sum(B) this will add up all the A's and all the B's then divide the total A by the total B
you will need to apply the same logic throughout you book to get the correct results
and remember LOD's are not aggregates and need to aggregate as above
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thank you! That is exactly the result I wish to get.
And, wow, so an IF function can go within the SUM aggregation. A new lesson learned. Really appreciate it!
Thank you for the clarification! Indeed, I constantly struggle with when and what type of aggregation should be applied. Reading more on this subject does help. Thanks again for your reply and for making it a bit more comprehensible.
glad to be of help - it it really helped you lease mark the response helpful to acknowledge the effort'Jim