Work Order Aging in Powerpivot

[butlerrbrian]

I am attempting to complete a report of work orders aging by days in 9 different buckets for columns, with multiple "customers" in rows. In Excel, I would use =COUNTIF with a nested AND to accomplish this, but I am struggling with it in Powerpivot. There is a different table for each "customer", but the measures are the same.

 

[butlerrbrian]

I appreciate the quick reply, however - the function merely returns #VALUE.

 

[powerpivotpro]

How about a table in PowerPivot with an =NOW() formula? Then you add that as a pivot field or cube formula. That might get updated even when you click a slicer but I don't think so.

 

[XLBob]

you need to refrence a cell in pivottable. Note do not use mouse to select cause it will nest a getpivottable function inside your formular. use keyboard to enter a cell refrence.
then add customer format dd-mmm-yyyy hh:mm to your rusult. It will work. I use this a lot.

 

[butlerrbrian]

Definitely works with cell reference, but changes every time the pivot refreshes, not the underlying data. Maybe the right question is how to get the data.csv timestamp in a cell?

 

[XLBob]

You need a trigger to let excel know to retrieve new data from your source. Have you tried to configure the connection property of your PivotTable.

</SPAN>

 

[butlerrbrian]

The connection is configured to refresh all tables every 60 minutes. I want to display the data.csv (not last sliced at) timestamp so that my users will know they have the latest data. It also allows me to audit how reliable the data source is.