Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to use calculate dimension so as to have count of customer codes on x-axis.
please advise guys
Please advise Guys..
Help Guys
please advise
Count # Customers giiving 80% of Sale
=sum(aggr(if(RangeSum(Above(sum([Actual Sale])/Sum(TOTAL [Actual Sale]), 0, RowNo()))<=0.8,1, 0), [Customer Code]))
michael
it says"
Allocated Memory exceeded......:(
Strange, you are 32 bits?
I attached you sample with the text box counter.
Try it !
No we are 64 bits
when I am applying the command into dimension, it says "Allocated Memory exceeds"
Sure, you cannot use an aggregation fucntion in the dimension.
Use the option text in chart (in Presentation tab) and add the formula within, then move the result where you want. with CTRL+Shift