Solved: SubTotal issue in PivotTable - Qlik Community

Bala_s · ‎2018-08-07

Hi Experts,

I have issue in SubTotal in pivot Table, I made check mark for show PartialSum, but still no luck.

I need to show Sales month on month for Countries and I need to provide Region wise SubTotal.

My expression is: only(Sales).

Request help here at the earliest.

PrashantSangle · ‎2018-08-07

Instead of only() use sum()

sum(Sales)

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

PrashantSangle · ‎2018-08-07

Instead of only() use sum()

sum(Sales)

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Bala_s · ‎2018-08-07

Thanks Prashant.....

I Thought if I use "Sum" values may get wrong...

It's working thanks for help!!