03-12-2015 02:18 AM
I am trying to achieve the same result as its developed in the attached screen shot but facing some challenges like I am not able to find a way to put multiple Categories and same names underneath. I have search each and every available source but didn't find any solution so please help me to get same result.
Can we use label for the measures as the data items can contain unique names only. as per the screen shot there has to be a way to make selection for a particular category.
I am using SAS Visual Analytic 6.4
03-12-2015 03:40 AM
From the screenshot the names of the measures data items are the grey colored background cells: Call Duration, Call Duration (minutes) and % Call Drops and that is why they are repeated for each of the 2G, 3G and 4G categories.
Please provide a screenshot on what you are attempting with annotations of what you would like.
03-12-2015 04:03 AM
There he was trying to show Calltech(Last) & Subscriber herarchie wise Contribution of Call Duration, Call Duration (minutes) and % Call Drops.
03-12-2015 05:17 AM
Attached screen shot is just an example and the same layout is my requirement.
I have different Measures and Categories and explaining here:
|Daily Sales Report||# stores||ADS||SSSG||SSTG||Seq. Growth|
In the above report we have three measures i.e. DAY, MTD, YTD which are variance between this year and last year, and all are calcualted saperately with respect to ADS, SSSG and SSTG.
I could only achieve the result attached in the scree shot (sample cross tab)
03-12-2015 05:59 AM
Thanks for providing the screenshot - this helps to understand what you are aiming for. It seems that you would like to nest measure data items and have the aggregation of Day within MTD and the aggregation of MTD within YTD and the aggregation of YTD within Day. If that is the case then it isn't possible.
To achieve the table you are after ADS, SSSG and SSTG would need to be levels of a single category data item and you use that category item in the cross tab. The calculations you did separately with respect to ADS, SSSG and SSTG is done by Visual Analytics. You would need to change your data preparation and load.
03-12-2015 06:27 AM
No, thats not the case.
See, lets talk about 1 by 1, I have a report called ADS which has Measures DAY, MTD and YTD, another one is SSSG, which has the same measures but calculated differently and same thing happens with SSTG as well.
The problem is, we can not create calculated item more than one having the same name.
So, is there any work-around for the same.
03-12-2015 06:57 AM
Thanks for providing some further explanation on your data items. In Visual Analytics you work on data items across the entire data source so if you have a DAY measure it will be for all report types. If you need to have DAY, MTD, YTD calculated differently for different report types then a work around would be to create them and name them as ADS-DAY, ADS-MTD, ADS-YTD so they can be added as separate measures within the report object.