Hi All,
I have a crosstab and am displaying department number in rows, year in columns and salary in measures.
i want to display department name under department number to display total for entire department.
For reference please find the attached.
Thanks in advance....
Regards,
Nagendra
The screenshot you have attached is it your requirement ? Cos from what you have given i dont think the crosstab is effectively used here the code and the name represents the samething what is the point of repeating the same measure twice when you know that the dept.no wise total will be same as dept. name total ?
Hi Suresh,
Please find the below attachment for clear understanding.
I want to display region name while dispalying locations realted to that Region.
Regards,
Nagendra
Quote from: callmenagendra on 20 Aug 2014 01:26:12 AM
Hi Suresh,
Please find the below attachment for clear understanding.
I want to display region name while dispalying locations realted to that Region.
Regards,
Nagendra
Hi,
It looks to me like you just need to nest location within region and summarise the locations?
MF.
If i nest it will display all regions for all locations.
Is there any alternate solution to do this?
Quote from: callmenagendra on 20 Aug 2014 05:21:19 AM
If i nest it will display all regions for all locations.
Is there any alternate solution to do this?
Sorry - I don't follow. What do you mean by this?
If you nest location within region, you will see the locations for a region within that region.
Can you explain what you mean?
MF.