Pivot table with Overall total not dependent on dimension values

[Manish]

Hi Guys

Is it possible to make below mentioned pivot table where i can have a company total at the end along with dimension total

Mandate	Managed	Non Managed	Total
State
A	10	5	15
B	20	6	26
C	30	7	37
Total	60	18	78
Company Total	100	20	120

[Anil_Babu_Samineni]

Yes, Please supply the data set to work or explain where did you fail?

[Manish]

I used valuelist like valuelist('',Company Total), and used pick and match to write expression but i couldn't strict the dimension "State  "  like i am able to do for expressions 

[Brett_Bleess]

Per Anil's comment, really going to need the QVW in order to have a look at things for you to see what may be going wrong.  If you have data you are worried about, you can use Settings\Document Properties\Scrambling tab to scramble any fields you wish to mask things.

Regards,
Brett