I don't believe you can trick Tableau into being illogical. Your formula is "Naturally" illogical, so then any alternative answer will have to also be illogical. Now if you can better explain what the number 3 represents and under what condition this magical new value would appear, then we can help you out.
Attaching a sample excel for reference.
It is a mock-up of the sheet in question.
Will not be able to share the original data. Feel free to ask if any mock-up for data is required.
When I turn on Row Grand Total , the Total Pane is shown(desired as format point of view) with no Values.
The Total Pane was number 3
Thanks in advance,
Total_QoQ_Issue.xlsx 45.9 KB
Minat, thanks for the clarification. I looked at your Excel file and sort of understand what you're trying to accomplish, but since you don't want to use Table Calculations we're going to need a better idea of how you're rolling your own QoQ calcs. Use the English Superstore data set and create a similar worksheet. Or just mock up some bogus data and use it to create a packaged workbook. Thanks,