on 10-21-2015 3:03 PM
Hi Nikhil,
Apply break on Area, Level and Location.
Hope this helps...!!!
Grtz
-Anila.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nikil,
try this :
1 - Create your Quarter object concatenating [Quarter]+"."+[Year}
2 - Create your cross table with all dimensions Area, Level, location on rows and your quarter objects and the other dimension as columns;
3 - Apply a break on quarter
4 - format the break as shown in the below image :
5 - format the Area as well.
Regards,
Rogerio
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Amit,
Thanks for the response.
Plzz check my original screen shot ,
What ever u suggested in u r second screen shot is displaying the data in blue color(as left header) as header. to change the color i can do the format cell options.but the header for that data we need to get in blue color. if i am not conveying clearly plz check once my attached file. in original post..
Thanks
Nikil..
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.