Hi All, Is there any way to create a report in excel using SAS that changes data based on the selected filters? My data has filter1 & filter2 and 4 fixed groups for both these filters. Each filters has 4 diff metrics and based on the combination of these two filters report has to be updated. I can only think of achieving this using VBA. is there any better option available if so please help me on this. Below is the example of my output in excel. attached sample data as well. Filter1 mode1 Filter2 channel2 Groups Units Sales A 0 0 B 15 200 C 0 0 D 0 0 Please let me know if you need more information. Thank you.
... View more