Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to calculate the sales target of the year?
Can you provide sample input and expected output
Sum(Sales Target)
Actually what do you want to ask,
Is sales target some field in data ???
For this you need the sales target value which most companies created at start of the companies business, and if you have that value then you can use simple aggregate function SUM( [Sales Target] ) and dimension Year or Month.
Regards
Anand