This content has been marked as final.
Show 3 replies

2. Re: Assigning a category based on a aggregate condition then counting members in category
Amit Narkar Nov 30, 2018 3:01 AM (in response to Yuan Howe Liak)You will need to use LOD calculations to get results
e.g. { fixed [Customer]:sum([Sales])}
this will calculate sales total for customers ignoring other granularity and use this for you category calculation
Please find the attached workbook for your reference.

Book1_v10.5.twbx 13.6 KB


3. Re: Assigning a category based on a aggregate condition then counting members in category
Yuan Howe Liak Nov 30, 2018 3:48 AM (in response to Amit Narkar)D'oh! In retrospect it's so obvious to just separate the if statements and the LOD sum() calculations. I was trying to combine the two
Thank you!