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:

Food category	Sales plan	Sales fact	Grand total plan
Brand 1	100	120	450
Brand 2	200	150	450
Brand 3	150	200	450
Food category Total	450	470	450
Grand Total	450	470	450

<tbody>
</tbody>

Thank you!