I have a pivot table with a text box referring to a cell outside of the pivot table with the following:
="Available Now " & GETPIVOTDATA("Available",$A$1)
I need to format it as currency and no decimals.
I thought I could do something like this:
="Available Now " & format(GETPIVOTDATA("Available",$A$1),"Currency") but it returns an error.
any ideas? thanks...