Hi,
I have a multipage report (inherited), to which I have now been asked to add three columns of data to each data source (demographic data of students who meet the qualification of the line item being reviewed). There are currently 8 different spreadsheets being used in this one report. Due to the way the data is pulled, the three columns aren't ordered the same way in each of the data sources. For example, on the grades sheet, Demographic colums 1, 2, and 3 show up on the first line of data. On the major change sheet, that combination of demographics might not show up until row 15 or 300. How on earth do I get these columns added without having to rebuild the entire report? Double frustrated because I had to do this same function in Tableau yesterday and it was SO simple to do (add columns to an existing data source--I refreshed the data and BAM! it was available for me to use).
Any ideas at all would be greatly appreciated.
