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
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.
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)
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.
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.
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.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.