1 of 1 people found this helpful
Based on the table above, I tried to achieve the result you wanted. I have attached the screen snip of how I have achieved it.
My underlying logic to get the total amount for sector 1 as 205 instead of 410, is to use this calculated field (Sector Amount) in the viz
IF SUM([Number of Records]) = COUNTD([Total amount]) THEN SUM([Total amount])
ELSE SUM([Total amount])/COUNTD([Total amount])
Hope this helps.
Hi Tushar, Zhouyi, Amar,
Thanks a lot for all your quick and useful answers It helped a lot !
Have a nice day,