Pivot table - Show null values as different calculation

[knraju123]

Hi Community,

I'm facing issue with Pivot table - Actually Pivot table is working fine for me, but facing issue with one scenario.

below screen showing correct,  May 2021 value 4,453 and June to Dec showing Null i.e correct - but I have to show different calculation value or any number..

same as ABC2 client values are showing in June, it should be greater June month...  similar as below clients

([Amount (USD)]*[Gross BPS])/12*0.5 as Revenue,   - 4453
([Amount (USD)]*[Gross BPS])/12 as WithoutBonus  -  8906   (can you please help me on this value, not able to get this value)

PFA,..

[knraju123]

Hi Experts,

Still I'm facing on this issue, can you please help me!

[Lafayette]

Click the PivotTable report. On the Options tab, in the PivotTable Options group, click the arrow next to Options, and then click Options. Click the Layout & Format tab, and then do one or more of the following: AdvancedMD Change error display Select the For error values, show check box under Format.