Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have a grid chart.
Could you help me to fix my aggregation expression for dimension to remove unlabeled tag?
If I remove aggregation from dimension, it works perfect.
Please find my attached file.
Thanks,
Use this as your dimention
=if(aggr(count([Purchase Horizon])/count(TOTAL [Purchase Horizon]), [Purchase Horizon]) >0,
[Purchase Horizon]&'a ('&num((aggr(count([Purchase Horizon])/
count(TOTAL [Purchase Horizon]), [Purchase Horizon])),'#,##0%') &')')
Use this as your dimention
=if(aggr(count([Purchase Horizon])/count(TOTAL [Purchase Horizon]), [Purchase Horizon]) >0,
[Purchase Horizon]&'a ('&num((aggr(count([Purchase Horizon])/
count(TOTAL [Purchase Horizon]), [Purchase Horizon])),'#,##0%') &')')