I have q question about Layout calculation at bottom of the report.
I have a drill through from Cube to Report studio report. In target report I have 4 filters as optional. I have to show this filters at bottom of the Target report. Using Layout calculation I added those parameters to bottom of the report.
parameters are product, Region, Year and Month
when I drill through from cube to report studio target report Product and Region filter exression showing properly means if I filter them, end of the report I can see the Product and Region information.
Year also showing fine. But if I filter the report on month level end of the report is showing Year and Month.
when I filter data based on the Month I need to display month only end of the report.
Note: Data looks fine in year and month level. I am having probelm with layout calcution to display time dimension.
anyone has any idea, how to resolve it.