2 Replies Latest reply on Jun 28, 2016 5:16 AM by khadeer.shaik.0

How to add Total Column(Based on condition) to a cross tab?

khadeer.shaik.0 Jun 23, 2016 4:52 AM

Hi All,

I need to add a total column in my cross tab:

I am using date field, when i trying to add a column it is slicing based on Date Column, so unable to add Total column?

Scen: If my quarter is >= Current Quarter then Sum(Sales)....i have to show total sales for current and future Quarters in place of Grand total:

i have calculation to calculate Total for Current and Future Quarters, but when i added it is slicing by quarter:"

Help me to resolve

Thanks

Shaikk

1. Re: How to add Total Column(Based on condition) to a cross tab?

John Sobczak Jun 23, 2016 5:03 AM (in response to khadeer.shaik.0)

Did you use if datetrunc('quarter', [Order Date]) >= datetrunc('quarter', today()) then [Sales] end ?
Like Show 0 Likes(0)

Actions
2. Re: How to add Total Column(Based on condition) to a cross tab?

khadeer.shaik.0 Jun 28, 2016 5:16 AM (in response to khadeer.shaik.0)
Hi john,

I have my column to add my view, it is not an issue about calculated field, what ever tha measure adding to view it is slicing based on Quarter dimension in column:

Please find attached Excel to know my issue, i tried to give clear explanation in both twbx file and Excel file in this Que.

Thanks for your valuable time.

With regards
Khadeer.

issue.xlsx 11.9 KB
Like Show 0 Likes(0)

Actions

Tableau Community Forums