Forum Discussion
Sum per Day
Hi,
I have this table visual with OrderDate and a Amount measure.
The OrderDate is of type Date, with Date Hierarchy off in the table.
What I´m struggeling to achieve is to visualize the total Amount per day, and not show all datapoints per each day. The OrderDate hierarchy needs to be off in the table.
Sample data
OrderDate Amount
2019-01-01 100
2019-01-01 200
2019-01-01 300
2019-01-02 200
2019-01-02 300
How I want the table to show the values
OrderDate Amount
2019-01-01 600
2019-01-02 500
3 Replies
Thanks you for reply!
That is what I have done, and the data is shown as following.
OrderDate Amount
2019-01-01 100
2019-01-01 200
2019-01-01 300
2019-01-02 200
2019-01-02 300
But I want the data to look like this
OrderDate Amount
2019-01-01 600
2019-01-02 500
