Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
selcukcadir
Creator II
Creator II

pivot table dimensions sub total

hi all,

dimensions:

=aggr(Sum (money(BTC_USD_2012,'##.##0 $')),SATICI,MUSTERI_ADI,ULKE_TANIMI)

dimensions subtotal  does not appear.

Expressions sub-total ok

added sample

3 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

   Try this.

   =sum(aggr(Sum (money(BTC_USD_2012,'##.##0 $')),SATICI,MUSTERI_ADI,ULKE_TANIMI))

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
selcukcadir
Creator II
Creator II
Author

hi,

   =sum(aggr(Sum (money(BTC_USD_2012,'##.##0 $')),SATICI,MUSTERI_ADI,ULKE_TANIMI))

error.

dimensions subtotal  does not appear.    (empty)


How to get subtotal ?  image (False)   empty

sample2.jpg

selcukcadir
Creator II
Creator II
Author

So how can I find a solution. thanks.