Hi Kalyan,

Please use groups to get the output. Refer the below screenshot. Please find the attached workbook. Its been created in tableau 10. Groups has nothing to do with tableau version. You can simply create groups.

Thanks and Regards,

Ashish Chaudhari

Hi Kalyan,

I have already attached the workbook in the first reply. Please check. You can calculate the totals and subtotals with a single click by going to Analysis option in the Menu Bar.

Please refer to the below screenshot.

Thanks and Regards,

Ashish Chaudhari.

Hi Kalyan

I hope you're looking for something like this.

Subtotals are done, their "Names" are re-labelled! Finally, to calculate the grand total of all Ps and Rs, name is given as "P+R Totals" and value is correct!
You can achieve this at dashboard level only. Please follow the Dashboard i created in attached Workbook./

Kindly do let me know it helps

Thanks

Rahul

In Addition to the first reply, I have mocked up the data myself! Never mind!
Some names are there with "R" and "P" and some respective Values!
Hope you got it

Regards

Rahul

Hi Kalyan,

You Can change rename the totals.

-Ashish Chaudhari

Hey Kalyan,

I have attached it to the original post.

You do one thing, open the question in a new window completely. then you'll be able to find. Never mind,I'm attaching again. Open it in separate Window.

Hope this helps you. Let me know!

Thanks

Rahul