HI
I have a report created which provides drill through functional using dimensional data. In the report you can drill down on facility - unit - room level. In the report in question you see facility A,B,C and summarized data such as room days, occupied days, % occupied etc. You drill down on facility and now you see the units with the same summarized information but i dont want users to drill down any further. if they do they see all the summarized information in the first room available and all else is 0's.
Please advise if a solution exists
regards
bunker