I am trying to alter the export of a default market profile report. Normally this outputs a single excel file with 3 columns of data (ie 1 mile, 3 mile, and 5 miles from target site), but I have a need to replace the 3 standard distances to be geographical areas. So, for example, I want them to show me the market data for a zip code, a state, and a city. I can run these reports individually, but I need them combined on one spreadsheet in the same exact format as the default mile radius report. I have tried running a custom report and generating an all in one PDF but it does not put the data in columns, it simply tacks the single line report to the end of the others (and is not in excel format).
Can anyone give me some insight on if it is possible to generate that single file with the sites listed as columns?
Thank you!
