how to get the total sales

[sonysree88]

Needs to display total sales made in each year. But the company maintains its sales transactions with full timestamp (dd:MM:yyyy:hh:mm) not just the year in form of DateOfSale column which is of Date type. What would you suggest Theon to do in order to meet this requirement

Which one is correct in the below :

1. In Query Editor, use Year function on DateOfSale column before performing GroupBy on DateOfSale

2. In Query Editor, use Year function on DateOfSale column after performing GroupBy on DateOfSale

3. In Query Editor, perform GroupBy on DateOfSale column

4. Group By is not required at all

[pradosh_thakur]

Why not have a year column as it can be used else where as well and then calculate the total sales by that year column?

[anushree1 · Accepted solution]

Use code as below:

Load

field1,

Fieild2,

Sales,

......

Year(DateOfSale) as Year

From....

;

No Need of grp by

use a straight table Dimension: Year(You created in Script) Measure:Sum(Sales)