Hi
I have a client that would like to build a dashboard based on Planning Analytics cubes where users could choose a month and based on that they would get relative month columns (Month, YTD, R12, and same columns but for Previous Year) in dashboard crosstab. I think I would need to have the possibility to choose a month from a dropdown list as the source and calculated the relative versions based on that. This is of course easy to do with reports. However it seems that I can't get the memeberunique out with the prompt function in the dashobard calculations. Does anyone have any ideas how to do it or if it's even possible to do?