Hello, I am creating a projected P&L based on sales that are active and have not closed yet to compare to the P&L I get for business closed from prior months. My table has about half the columns that I can easily unpivot but the other half of the data are calculated columns and measures that I need to unpivot and cannot find a way to do that. If I cannot do that I will have to edit my query and create the columns all over again in query editor to allow me to unpivot the rest of the data but I don't want to go through doing all the work that I already have done. I have tried using the matrix visual and "show on rows" but the problem with that is that I cannot group fields and it will not total all the columns when I "show on rows" the way it would have if I could have unpivot the data, group it, and have it automatically total the values. Any ideas?
