Want to get Column Total in Row

[ferha_jafri]

Hello Experts,

I want to add column total and get its value in row.Please find attachment as you will see in the attachment I want to get column Total on the right hand side value in the Total row.

Thanks in advance.

[Anil_Babu_Samineni]

Like this?

[ferha_jafri]

No 

[Anil_Babu_Samineni]

Please describe in image after you export that into excel.

[ferha_jafri]

If you check the pivot attached in the sample I want column total on right to come in expression name as Total. 

[sunny_talwar]

You want something like this?

[ferha_jafri]

Thanks for your reply but I want to get for priority 1,category 1 total which is 4 to come under total for priority 1 , category 1.I want to evaluate % for them as there corresponding value 3/ 4.

[ferha_jafri]

Hello ,

Not able to find solution to this , if anyone worked on a similar case then please reply.

[sunny_talwar · Accepted solution]

This?

Expression for TOTAL

Count(TOTAL <Prioity, Category> Documnet)

[ferha_jafri]

You are great , thank you so much this is what I was looking for...