Forum Discussion
New Column with Total Sales
I can't seem to figure this out and looking for some guidance. I have the following table
| Date | Sales |
| October 2017 | $600 |
| October 2017 | $300 |
| October 2017 | $1,000 |
| September 2017 | $600 |
| September 2017 | $500 |
| September 2017 | $1,300 |
| August 2017 | $2,200 |
| August 2017 | $250 |
I want to add a 3rd column that adds the monthly sales. Any suggestions?
| Date | Sales | Monthly Total |
| October 2017 | $600 | $1,900 |
| October 2017 | $300 | |
| October 2017 | $1,000 | |
| September 2017 | $600 | $2,400 |
| September 2017 | $500 | |
| September 2017 | $1,300 | |
| August 2017 | $2,200 | $2,450 |
| August 2017 | $250 |
9 Replies
Hi,
If your objective is to see the Monthly Total in a visual, just drag the Date column to your visual and write a simple SUM measure to add the numbers in the Sales column. Why do you need a Monthly Total column in your base data table?
Hi Ashish,
I didnt provide my end goal as I thought by getting the answer would point me in the right direction. So here is my end goal. I also have another table similar to the on below. It also only has the first two columns. My goal is to calculate the the difference of estimated and actual sales by month and then in the visualizer graph the difference by month.
Date
Estimate Sales Estimated Monthly Total October 2017 $900 $2,100 October 2017 $400 October 2017 $800 September 2017 $200 $2,700 September 2017 $1,000 September 2017 $1,500 August 2017 $1,800 $2,300 August 2017 $500 Hi,
To accomplish that, we do not need to do what you originally asked for. Share both datasets and show the expected result.