Dimension

[smilingjohn]

Hi All, 

Currently i am showing a bar chart with one dimension and one expression . 

IN dimension i am showing Category which displays  Age,Dept,Sector,Gender totally four bars will appear and expression is sum of expenses. 

Now i want to include one more bar in this within category like i want to group altogether and display one more bar as all 

so that now the bar chart should 5 categories like ge,Dept,Sector,Gender and ALL. 

How can i achieve this  within the dimension itself ?

Thanks in Advance 

[Vegar · Accepted solution]

The easiest solution is probably to remove the category  dimension and replace it with 5 measures.

Sum({<Category *={'Age'}>}Expenses) 

Sum({<Category *={'Dept'}>}Expenses) 

Sum({<Category *={'Sector'}>}Expenses) 

Sum({<Category *={'Gender'}>}Expenses) 

Sum({<Category *={"*"}>}Expenses) 

[smilingjohn]

 Vegar,

Thanks for the reply . This is giving me the solution what i wanted . The only problem is the the legends are not appearing below  the bars but the legends are showing on the right side chart vertically as shown in the attachment .

How to make the legends appear below the bars ?

[Vegar]

I don't have QV in front of me, but I would look around in the  properties tab that are handling styling of the axis. 

(You can also remove the dimension from your dimension list if it's still there.)