total in pivot table

[ssriramin19]

  Below is the requirement screenshot (as from excel requirement)

            

Below is the actual image with the above chart created in pivot table. My question here is how to achieve the grand total in the above chart .The total portion is highlighted . the total needs to be calculated only for the mentioned columns. Total needs to be appear after the column december .How this needs to be achieved?

Can you please suggest some approach on getting this .

[jagan]

Hi,

You need to give it in the expression.  Suppose if you have expression like Sum(Sales) then you have to change it to =If(RowNo() = 0, '', Sum(Sales))

If not working then attach sample file, then it will be easier to understand your chart dimensions & expressions and can provide the correct solution.

Check this link for getting the solution faster

Qlik Community Tip: Posting Successful Discussion Threads

Regards,

jagan.

[ssriramin19]

But the application size comes around 27 Mb,Actually I have placed the screen shot of the image above .One with the requirement which has the total and another is the report output screen shot. Will it not suffice?

[jonathandienst]

Screen shots help to explain the problem - they rarely help with fixing the problem.

See Preparing examples for Upload - Reduction and Data Scrambling

This will explain how to reduce the data volume (and scramble sensitive information) for upload

[Digvijay_Singh]

Like this?

[ssriramin19]

But I tried with you approach but unable to get it correctly .

[vikasmahajan]

Better you create sample apps and attach for solution

[ssriramin19]

The report has been attached.I need to include the total values as per below

The report needs to be referred to second tab in the attached qvw.

Please suggest an approach

[ssriramin19]

can anyone provide me the approach on how this needs to be achieved.The actual qvw file has been attached and requirement image has been placed here.

Please do the needful on this.

[ssriramin19]

can you please explain how to proceed further as I have pasted the qvw file and also the requirement as an image has been placed here.

Please do the needful on this