Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have below expression in pivot table and Date as dimension
=if(TAT>=0 and TAT<=3, TextCount(DocNo))
Total at the bottom not showing any value
Seleted show partial sum for Date
Thanks in advance
Hi,
Not sure you try this yet
TextCount(if(TAT>=0 and TAT<=3, DocNo))
Regards,
Sokkorn
Hi,
Try this.
Sum(Aggr(if(TAT>=0 and TAT<=3, TextCount(DocNo)),DATE))
Regards,
Kaushik Solanki
A little explanation.
Total make sense only for aggregation. For example, if your expression is
Amount
there can be no total. To get total, you have to use
sum(Amount)
KS recommends to use sum() as your expression, so the total is clearly defined.
Regards,
Michael
In this case if not executing correctly.
Count is not coming correct for some date
TAT is based on DocNo
Hi,
Yes.
To get the total's, your expression should have aggregation functions like Sum,Avg,.. and so on.
Regards,
Kaushik Solanki
Hi,
Not sure you try this yet
TextCount(if(TAT>=0 and TAT<=3, DocNo))
Regards,
Sokkorn
Worked
Thanks alot