Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have made a pivot table as given below by extracting data from an excel sheet.
_________________________________________________________________________________________________
Code || April | May | June | July | August | September | October | November | December | January | February | March |
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Now I want to add an extra header row above as :-
| Q1 | Q2 | Q3 | Q4 |
_____|________________ |______________________|____________________________|_____________________|__
Can someone please help me out with this??
Divya,
The answer is same as I stated just above. If you have doubt, please cheate a sample qvw with your sample data inline and post it creating a new thread.
Hi,
here Month and quarter are irrelated.
if Quarter is realted to Month then only you can plot quarter and month mapping properly.
if you calculate Month and Quarter from Date field then definelty its provide you accurate mapping b/w quarter and months.
and if you insert new data also in db .then it will automaticlly get reflected in your table after reload.
hope this helps
Tresesco n Sunil...thanx for the help
The second dimension which I use gets arranged in alphabetical order, what if I want it to get loaded in the load order??
Do you find any difficulty there? In the sort tab, select the dimension and set the sort option accordingly.
Ohh ya thanx...
