Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to create a stacked bar chart that shows the distribution of expenses (Over budget amount,Under budget amount,team costs and expenses).I have different columns in my datasource for team costs,expenses,budget and Remaining budget.Will I have to reorganize my data set and add a column that categories various values as teamcosts or expenses to get the stacked bar chart?My dataset and objective is:
Is there any other workaround?
Thankyou so much!
I found the solution!
I did this by Pivoting the table in data set like:
I have aggregated all the expenses,teamCosts,Remaining budget values for each client by pivoting it.And then transformed it as shown.
Hope this helps someone. 🙂
I found the solution!
I did this by Pivoting the table in data set like:
I have aggregated all the expenses,teamCosts,Remaining budget values for each client by pivoting it.And then transformed it as shown.
Hope this helps someone. 🙂