Forum Discussion
Hiearchy with value fields
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
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 😀
3 Replies
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 ?
exactly jaideepnema
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 😀