Issue Updating Pivot Table Consisting only of a Measure

[Andrew_UK]

Hi All,

I've never tried creating a table before that only consisted of a singe measure, It seemed pretty straightforward though... or so I thought

The theory is that it's sat on a dashboard page and just shows "Invoiced so far today". When the user refreshes it should update to show how much we have invoiced up to the minute. The figure in the Powerpivot Window has updated and now shows the correct value (lets call it £100k), whereas the figure in the pivot table on my dashboard page still shows as £50k. I try refreshing the pivot table - nothing changes - I've checked that Calculation Options are set to Automatic, they are.

If I rebuild the Pivot table then it shows as £100k, but I just can't seem to get it into a refreshable format.

Is there some known issue when building a pivot table that ONLY uses measures while the Rows/Columns/Filters/Slicers are all blank? I googled but couldn't find any such known issues.

Thanks in advance!! Andrew

 

[Sinon]

Without seeing your workbook it's difficult to say. As you mentioned, as long as Automatic calculation is checked it should update. Unless the formula you're using to get the info from the pivot is acting up. Can you post a sample?