Irfan -- Are you on 10.1? I guess I need to get the next version installed...
In the attached superstore example (8.2, so it will upgrade to any version) I made a simple chart and added an INDEX calc to the display to demonstrate what Rekha suggested.
Sheet 1 has the index running TABLE(across).
Sheet 2 has it running TABLE(down).
Sheet 3 has it running TABLE(across then down).
Sheet 4 has it running along specified dimensions (region, category, and then Year, in that order.)
Sheet 5 has it running along the same dimensions, but restarting for every REGION.
This is a powerful table calc function for you to use, especially if you get adept at telling it how to "walk" through your table.
Here's a drastically simplified view and with that the default table calculation compute using of Table (Down) will work:
There's no need for the multiple axis crosstab trick to get Customer Name listed instead that's on Rows, to get rid of the Abc's I used a Polygon mark type and removed the Column border for Pane.
v10.1 workbook is attached.
Thanks a lot for your quick reply, Actually I have used multiple axis because my boss wants customers name in colors according to the region. Is there any option to get index number in the same format which I used?
Thanks a lot for your reply, It is working but you have removed dual axis functionality due this I am unable to put the header name.
Can you please suggest me how I can put the header for the column-
Sheet2.JPG 173.1 KB
The problem with dual axis is that you can box yourself in with functionality. It's a powerful feature, and (in my opinion) the power of dual axis is being wasted simply to add a label. I have found myself working on sheets that need dual axis for something more important, but it's already a dual axis sheet, so leveraging that feature isn't available to me.
Take a look at the attached.
In the dashboard I put the Sheet 2 I did for you, and then I floated a text box over it to add the label.
In Sheet 3 I created another dimension calc with nothing but a blank in it. I called it [Region ] I added it to the sheet as a column, and it's header looks like the column label for the regions. Yes, there is an empty region on the sheet where the blank value is displayed. You can format that out of there. Users won't know the difference.
So that's two ways to address your need.
But if you must have dual axis, I just modified the index calc on sheet 1 to the same settings as they are on sheets 2 and 3.
IndexSample 3.twbx 1.2 MB
Thanks a lot Joe.