My data source contains columns that have a Y/N indicator. I have one group which there are 15 columns listing each item in that group and then I have a second group with another 15 columns listing each item. I need to pivot the data in Tableau to get the view I want for reports, but I can only seem to have one pivot in Tableau - but this will not work since these 2 things are separate and cannot be combined. Is there a way to create a separate pivot? or maybe after doing the pivot create 2 groups within that?
You can do this easily in Tableau Prep.