Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
WHat is calculated dimension in chart properties ??
Please help.
Thaks.
Calculated Dimension is a dynamically calculated field, which is derived from one or more fields.
Consider that you want to have only Customer from specific country i.e. Germany....
you can use
IF(Country = 'Germany', Customers)
as a Calculated Dimension..
More complex, if you want only top 5 customers...
you can use combination of SUM, Aggr, Rank to get the result..
IF(Aggr(Rank(SUM(Sales),4),Customer)<=5, Customer)
If you want to divide your sales in a group of 1000 and need to have customers falling in this group. ...
=Class(Aggr(SUM(Amount),Customer),1000)
and Expression = COUNT(Distinct Customer)
Hope this helps..