I don't think you can force the level of aggregation as the aggregation is always dependent on the dimensions you've used within the report structure itself.
I was just wondering there has to be some another way through which above situation can be tackled.
What's wrong with having the Merchant ID on the row/column shelf or the Detail mark?
Attach an example Tableau Packaged Workbook and people might be able to give you some other ideas.
If I'm reading this right, it looks as though it could be completed with a window_sum addressing the MerchantID as this could be achieved using the Sum Over clause in SQL, though you may have to be performing the calcs outside of Tableau as a temp table or derived table would be of benefit here
If i use Merchant ID in the detail section, then records are separated based on the distinct number of Merchant ID's.
Attached is the packaged workbook, in %sheet there are 2 rows and my desired values are 3 and 1.
Hi Tom/Steve/Tableau Community,
Is there other way through which my problem can be addressed. I have tried all other means however i am still not getting the desired results.
I am attaching the sample workbook again. The raw data sheet contains all the data, in the '%sheet' i just want the value as '3' and '1' for 'Region A < Region B' and 'Region A > Region B' respectively.
Let me know if i need to be more clear on this.