Menu Title should have Text and Distinct count Numbers for Menu Title.
To get both combined as union in Custom SQL below query
Union
1st table contains Text
2nd table contains distinct count of Text
Example below
Is there any workaround to resolve this issue am using UNION i have attached query in spreadsheet. as you said tableau Calculate those Total and Grand Total but the Total count of title will be a separate column and i have to get below. as per the requirement order of the column remain same also shared the spreadsheet. this will not allow Total and Grand Total to show for the below mockup attached spreadsheet.
Attached Mockup and Workbook.
Please refer earlier conversation
Hey @Vicky P Thank you for providing a mockup and a sample workbook. There are several things different between the mockup and the Tableau workbook, so I'm having trouble determining what exactly the question is. Is there an issue with the SQL query not returning the expected values for [Total]? Could you provide a specific example of the issue and what you expect? For example, you might say something like "The total for run date 2/12/2024 is <1MM but I expect it to be >1MM and <3MM because..."
Hope that helps!
Esther Aller
If I helped, please mark the question as answered :D
