Subtotal in Pivot calculated field

[b0unce]

Hello,

Is there a way to display Grand total in calculated field in PIVOT in columns (but display grand total of rows)? This grand total should show TOTAL value of all visible (filtered) values. I will then use this calculated field in PIVOT chart to display total planned sales of certain filtered category.
Example:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Food category[/TD]
[TD]Sales plan[/TD]
[TD]Sales fact[/TD]
[TD]Grand total plan[/TD]
[/TR]
[TR]
[TD]Brand 1[/TD]
[TD]100[/TD]
[TD]120[/TD]
[TD]450[/TD]
[/TR]
[TR]
[TD]Brand 2[/TD]
[TD]200[/TD]
[TD]150[/TD]
[TD]450[/TD]
[/TR]
[TR]
[TD]Brand 3[/TD]
[TD]150[/TD]
[TD]200[/TD]
[TD]450[/TD]
[/TR]
[TR]
[TD]Food category Total[/TD]
[TD]450[/TD]
[TD]470[/TD]
[TD]450[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD]450[/TD]
[TD]470[/TD]
[TD]450[/TD]
[/TR]
</tbody>[/TABLE]

Thank you!