Total problem in pivot table

[sarfaraz_sheikh]

Dear All ,

I am facing the problem regarding total...

As of now Total looking like below:

Output Total Should be like below:

Total                        Amount                  25140548            557844               -98       

                                Count                        628                   15                    -98

If we see in above format TOTAL is showing only for count after checking on show partial sum over RoleName Dimension...........But it should apears for both Amount and Count ...Strange behaviour...

Can any one help me with this ..............

My QVW is also attached here for your reference.........

gwassenaar‌, jagan‌ , hic‌ please comment

Sarfaraz

[sujeetsingh]

For explicitly doing this you need some changes and tricks. Well check whether this will do

[prashantbaste]

Hi Sarfaraz,

Are you comfortable with below output...

If yes... check Attached QVW.

Changes made in Presentation are Tab -> Show Partial Sums -- Select Dimension & Expression by which Total is expected.

[krishna20]

Hi,

Is this your expected output....??

[sarfaraz_sheikh]

Hi Prashant,

Thanks for your efforts .........I already tried what you have done but that is not a expected output ....

Expected output should be like below....

Sarfaraz

[sarfaraz_sheikh]

no... not  expected output ...both should show in one Table only....is this possible.....

Sarfaraz

[prashantbaste]

You will need to make a small change in Script.

Join 'Total' to your data as -

Load Distinct StatusCount, StatusCount as NewField from table1;

Join

Load StatusCount, 'Total' as NewField from table1;

Now use this NewField in dimension and write expressions (with respect to StatusCount) this will display values for individual level as well as Total level.

Hope this will be helpful for you.

[prashantbaste · Accepted solution]

Please find attached QVW ... this is the solution that you are looking ... Right?

[nikhilgarg]

Hey,

Is this acceptable? See the snapshot attached.

[sarfaraz_sheikh]

Dear Prashant,

Thanks for your efforts...

I go the solution as expected  ..........be grateful to you ......Great work.

Sarfaraz