This content has been marked as final.
Show 2 replies
-
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 ?
-
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
-