Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Seperate total Values

Hi All,

I'm currently having problems seperating total values on my pivot chart.

MonthSegmentAmt
Oct 20788814.93
OctA20788814.93
OctB20788814.93
OctC20788814.93
OctD20788814.93
OctE20788814.93
OctF20788814.93
Oct-20788814.93

MonthSegmentAmt
Nov 19838230.06
NovA19838230.06
NovB19838230.06
NovC19838230.06
NovD19838230.06
NovE19838230.06
NovF19838230.06
Nov-19838230.06



Now, When I select both MONTH.

MonthSegmentAmt
Oct
40627044.99
OctA40627044.99
OctB40627044.99
OctC40627044.99
OctD40627044.99
OctE40627044.99
OctF40627044.99
Oct-40627044.99
Nov
40627044.99
NovA40627044.99
NovB40627044.99
NovC40627044.99
NovD40627044.99
NovE40627044.99
NovF40627044.99
Nov-40627044.99

It totals up Oct & Nov. IS there any way I can seperate the values?

I am using the total in the expression

Thanks

1 Reply
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

HI,

     Try your expression for Amt as below.

     Sum(total <Month> Amt)

Regards,

Kaushik Solanki

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