Hiearchy with value fields

[Anonymous]

Hello Everyone,

Is it possible to create an hiearchy based on value fields?

I have 4 value fields in my data: 

I want to create an histogram but when clicking on total it shows me all expenses well detailed 

Is it possible ?

Thanks in advance

[jaideepnema]

Hi @Anonymous ,

I am unable to visualize the end result you are expecting. So as far as i understood you want one bar that shows the total and if i drill down further it shows me the bifurcation for house,sports and work expenses ..Is that correct ?

[Anonymous]

exactly @jaideepnema 

[jaideepnema · Accepted solution]

Do you have a row-wise category against each row ?

If we need to show the total for each sort of expenses then unpivot the columns and create visual as given in the attached file.

Please accept this as a solution if your question has been answered !!

Appreciate a Kudos 😀