Tableau Community Forums

Hi Gerardo,

I have come across one issue with sub totals when used WINDOW_MIN(MIN([Pname]))=WINDOW_MAX( MAX([Pname])). Sum got greyed out in Total using calculation in swap measures and dont have any control on it. Results are incorrect when i select single Pname only.

If i use MIN([Pname]))=MAX([Pname])), it works fine and have ability to control the subtotals such as Sum/Avg/Min/Max etc. But my logic fails if i use this Min/Max logic.

Any suggestions , please!

Thanks,

Ashok.

PFA.

I am using the most recent workbook which has been modified by you.

Please look at the dashboard 1.

Expected Results:

When Pname=OTHER is selected, should display the results as highlighted in yellow in the swap measures along Name, Type measures.(I have created Results field for your reference)

Values are displaying correctly, but not the subtotals and grand totals in column 1.

When more than 1 Pname is selected or none of the Pname is selected, the field highlighted in yellow should hold the existing logic , which is working properly.

Subtotals & Totals are working fine for this scenario.

Thanks!

Hi Gerardo,

Seems like everything is working fine except one case. I do have other quick filters as shown.

When I select a value from Dname, then results in GV Swap Measure are incorrect. Expected results should be as shown in column1(Green box). Column1 is retrieving correct results for all filter conditions except Sub-Totals.

I tried to include Dname & Month in the LOD and worked fine for this filter criteria, but whichever worked for other filter criteria getting failed. Please advice.

However when i select all other values from Market/Month/Single or multi select on dname, results are correct. PFA workbook.

Thanks!

If I include other Dimensions in context, then which ever is working earlier having wrong results as shown below. Please advice.

MCode: All

Market: All

Month: All

MCode: All

Market: All

Month: Sep & Oct 2017

MCode: All

Market: WORVC

Month: All

Thanks.

Great Gerardo.. Looks good so far and will let you know for any issues.

Appreciate your help...!!!!

Hi Gerardo,

I have encountered small issue in grand total % as highlighted in Red color and even works for multi select or no select on Dname, but not on single select.

% logic: column3/Column1 i.e. (298.2/954.2)*100=31.25% is the expected results and this functionality should happen irrespective of any filters. PFA workbook for your reference.

Thanks!

Sure Gerardo,

As suggested, I have posted a new a new question. below is the link for your reference. Please look into it when your time permits.

https://community.tableau.com/message/749503#749503

Thanks in advance.