Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i have a bar chart with grouped items
i would like to add a line that shows the total of the values for each group
is there a way to do this ?
thanks
here is a sample of my data:
DEP | TRANSACTIONS | DATE |
a | 1113 | 01/15/2018 |
b | 1092 | 01/15/2018 |
c | 755 | 01/15/2018 |
d | 552 | 01/15/2018 |
a | 1109 | 01/16/2018 |
b | 1254 | 01/16/2018 |
c | 563 | 01/16/2018 |
d | 480 | 01/16/2018 |
and a screenshot of my chart. the line i want to show sums the total transactions (added in red):
thanks!
Thanks for your reply, but a combo box is not a good option for me, as I need the dimensions to be grouped, that is I need to see a bar for each department on the graph, no matter how many drill downs I do (year, month, quarter, week, day)
I don't think a combo does this