Cube Value Formula Not Returing values.

[Mavericks334]

Hi,

I am trying to create a summary report with the column Name as the Month and Metric. However since i have more than 15 Metrics to display.I have created a summary sheet and tried using the Cubevalue formula to retrive the values accordingly so i need to scroll to the right for more than 12 Columns which are the Month Names on the top. I get the below errors when i try the cubevalue formula but the value for that corresponding Month

=CUBEVALUE("PowerPivot Data","[Measures].[Actual Sent]","[Month].[Month]","[Month].[Month].&[September]") =#Value

=CUBEVALUE("PowerPivot Data","[Measures].[Actual Sent]",Pivot!$C$21,"[Month].[Month]","[Month].[Month].&[September]") = #N/A - Here C21 is month from the pivot sheet

=CUBEVALUE("PowerPivot Data","[Measures].[Actual Sent]","[Month].[Month].&[September]") = Blank



-- removed inline image ---


Any suggestion how could i get the value.

Regards,
Renato.

 

[Mavericks334]

Figured it out. Since i was using the slicer i have added the same in the cuber vale formula.

=CUBEVALUE("PowerPivot Data","[Measures].[Actual Sent]","[Month].[September]",Slicer_Type)