Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have one bar chart and pivot table in that i have used same dimension and expression but why value has changed.
PFA for the same
Thanks
Prashant
Could you share your doc?
Hi,
I suppose it has something to do with the fields you show in your Pivot-table. Copy the table and try to delete one by one until (so I hope) it shows the same value as in the bar Chart.
BR
Michael
Tranform your pivot i a bar chart ... check the result
if you look at the table and the row Grand total, the value is not correct.
if you add the previous rows you will get the value of the Chart.
if you Change the Expression from total to sum of rows you will get the same values
something does not match. look also at column commm no and the sum
Hi,
I copied and delete one by one as you say but no result matched.
Thanks
PM
Definitely your Grand Totals sum in PivotTable does not match the field records totals.
Can somebody open the file? I can not.
I am unable to open file.
any idea?