Is there a way to use cubevalue function that will prompt a user to input a value before it runs?
This is my formula:
=SUM(+N(CUBEVALUE("PowerPivot Data","[Measures].[Sum of PO_MTDY1]",Slicer_Dept_and_segment11,Slicer_Month11,Slicer_Period_id2,)))
I would like the user to input the value for Slicer_period_id2