6 measures on Column shelves and want x axis labels on top
Hi All,
I have below view with 6 measures on column shelves. I want to move column header from bottom to top.
Need your help!
Thanks!
Raj
-
1. Re: 6 measures on Column shelves and want x axis labels on top
Hi,
Go to analysis section select table layout and select advanced and a window will open unchecked this button
-
2. Re: 6 measures on Column shelves and want x axis labels on top
This works if you have dimensions in your column shelf. If you have measures in column shelf, then it does not work.
Thanks!
Regards
Raj
-
3. Re: 6 measures on Column shelves and want x axis labels on top
1 of 1 people found this helpfulHi Rajesh,
Check below this is what you are expecting right.
Drag measure names in column and drag measure values in column
-
4. Re: 6 measures on Column shelves and want x axis labels on top
Hi Tharashasank,
Thanks for your help. It helped and I was able to move column header to the top. But I have now another problem, It takes all the measures to the column shelf. If I take any column out from the measure card, then measure card is shown on filter shelf. If I show the filter, then it has that measure also which I have not selected. Filter should not show the measure which is not in the view.
Waiting for your help.
Thanks!
regards
Raj
-
5. Re: 6 measures on Column shelves and want x axis labels on top
Hi ,
Please post me the screenshot.
As per my understanding , Go to the filter shelf right click the pill and click on filter then only select the measures which you want to show in the view.
-
6. Re: 6 measures on Column shelves and want x axis labels on top
lei.chen.0
May 9, 2016 8:01 PM
Hello Rajesh,
Rajesh Agarwal wrote:
If I show the filter, then it has that measure also which I have not selected. Filter should not show the measure which is not in the view.
You can add measures which are not in the "Measure" list into "Measure Values" shelf too.
For example,
right click "Customer ID" in the "Dimension" list without releasing the mouse, and drag it into "Measure Values" shelf, then release the mouse.
A dialogue box "Drop Field" is popped-up, and two options, CNT and CNTD are available for you to choose.
Regards.
-
7. Re: 6 measures on Column shelves and want x axis labels on top
Hi, good morning.
See this example.
