Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello
i use drill down chart
for actual and plan collective sales amount (month 2 =month1+2,month 3=month 1+2+3,....)
for actual sales i use this formula and its worked but current month is 3 and after that the numbers are repeated(see the attachment)
round(Range Sum (Above(sum( sales),0,Row No())),1)
how can i fix that ?i want dimension shows number until current date
(when i click the number it shows week and the it show days) so in each steps show data until today
in fact i want the numbers in dimention show until there is a data for that,and dont repeat the last data for next month or week or day
May be this
If(Sum(sales) <> 0,
Round(
RangeSum(Above(Sum(sales), 0, RowNo()))
, 1)
)
its getting better thx but
If(Sum([sales) <> 0, Round( RangeSum(Above(Sum([sales)), 0, RowNo())) , 0)
actual must be :
1= 128 2= 667 3=...
but now
1= ... 2= 128 3=667
one back!