PowerPivot formula on a new measure using cell value

Hi All,

I am using PowerPivot to create a report from a ZAP datacube.  
The information that I have brought into the 'Powerpivot Window' is stuff like -
Sales,  GP,  State,  Month,  Year

I am looking to create a measure that will allow me to divide the GP by a cell value - sort of like this
=Query[MeasuresGross Profit]/p4
(where cell p4 contains the trading days gone in the current month)

Unfortunately the error I get is "Failed to resolve name 'p4'. It is not a valid table or a function name."

Can someone please tell me how to perform calculations on measures against cell values

Thanks

Anthony
ftechintAsked:
Who is Participating?
 
bromy2004Commented:
If the cell is populated from Power Pivot you can reference that Data
i.e.
=Query[MeasuresGross Profit]/[MeasuresCost]

or something along those lines
0
 
TracyVBA DeveloperCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.