You can achieve this in multiple ways. Using below mentioned calculations you can get your expected results.
TODAY() //2016-10-05 Today's Date
DATETRUNC('week',#2016-10-05#) //2016-10-02 first date of this week
DATETRUNC('month',#2016-10-05#) //2016-10-01 first date of this month
DATETRUNC('quarter',#2016-10-05#) //2016-10-01 first date of this quarter
DATETRUNC('year',#2016-10-05#) //2016-01-01 first date of this year
Let me know If you've any query.
Itz working fine but the only problem is tableau getting aggregate all data on date level.
I want all column separately just in normal cross tab.
Today week month year
Brand 10 20 30 35
Retailer 5 8 9 10
Segment 6 7 10 15
Make all the date fields as exact date and discrete. And change the format also.
If you still unable to get then share a sample workbook in .twbx format.
Find attached copy at main thread. Please Update!!
Plz Update!!! i have attached .twbx file in main thread.
I think you can try WTD , MTD, YTD for these dates.
Thanxx!! but itz not like that....i have posted example and attached sample .twbx file for it.
I just want to show table value as it is on the given period.
How i am looking at it is that for today(6th oct) lets say for a particular brand there are 10 (points) for the the whole week the value is 20, for whole month its 30 and for year 35.
Is this what you are trying to display...??
i am looking for nrmal cross tab with column today week month and year.