
1. Re: TOTAL CALCULATION
Sumeet Bedekar Dec 24, 2016 9:53 AM (in response to triveni namballa)1 of 1 people found this helpfulHi Triveni,
Let me assume that you want to use total sum of last 15 days with some other calculation.
Here is one try We can use to Window Sum to get the one single number.
In below example I have used YTD Sales.(last 15 days)
We can see that Total for YTD is 733947.
Now, create one calculated field YTD Total Sales
WINDOW_SUM(SUM([YTD Sales]))
this is will give one single number i.e is 733,947
Hope this answers to your question
Regard,
Sumeet

2. Re: TOTAL CALCULATION
triveni namballa Dec 24, 2016 8:06 PM (in response to Sumeet Bedekar)1 of 1 people found this helpfulHi sumeet ,
Thanks for the reply. Here i got the value for 15 days sales but in a next sheet i want (15 days sales total) (cuurnt sales total)
When i am dragging that total 15 days sales value into other sheet it is giving overall sales total . I want only to show that 15 days sales total only. How will it possible?