Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends
Why partial sum for "Total Sale" is 0 ?
Hi
Try like this
= If(RowNo() = 0 or IsNull(RowNo()), Num(Sum(Aggr(Sum({<YearMonth={"=YearMonth"}>} Foroosh)* (Fe),CodeKala)),'###,###,###.#0'), Sum({<YearMonth={"=YearMonth"}>} Foroosh)* (Fe))
Hope it helps
Hi,
go to chart properties --> Expression tab --> select sum of rows in total mode
Regards
ASHFAQ
Hi Mohammed
Total Mode is disable (grey) in Expression tab.
try below
=(Sum({<YearMonth=YearMonth>} Foroosh))*(sum(Fe))
Regards
ASHFAQ
Hi
Try like this
= If(RowNo() = 0 or IsNull(RowNo()), Num(Sum(Aggr(Sum({<YearMonth={"=YearMonth"}>} Foroosh)* (Fe),CodeKala)),'###,###,###.#0'), Sum({<YearMonth={"=YearMonth"}>} Foroosh)* (Fe))
Hope it helps
Thanks , Dear Mayil.