Hi All
I have below diamension :-
=$(ColumnDim_p)
=if(aggr(sum(sales),$(ColumnDim101)) / aggr(sum(total <$(ColumnDim_p)> sales), $(ColumnDim101)) > 0.001, $(ColumnDim101), 'OTHERS')
I have below expression :-
sum({$<year = {"<=$(=max(year)) >=$(=max(year)-12)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}
$(ColumnDim51)/$(Columndim89))
/
sum({$<year = {"<=$(=max(year)) >=$(=max(year)-12)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}
TOTAL <$(ColumnDim_p)
> $(ColumnDim51)/$(Columndim89))
Above chart work fine , But it take long time to create the chart.
Hope some one can advise me where go wrong ? I mean how to simplify the above syntax , so that the chart can load faster.
Paul