Row level division calculation is possible in EG but we want to show output in SAS VA which should be aggregated but right now it shows the summation of the row level in EG. Kindly suggest some solution. Finyear State City income expense expratio 20142015 Guj Ahmd 100 80 0.8 20142015 Guj Vadodara 200 150 0.75 20142015 Maharashtra Mumbai 250 200 0.8 20142015 Maharashtra Pune 200 100 0.5 20152016 Guj Ahmd 150 100 0.66 20152016 Guj Vadodara 120 100 0.83 We want to show this data in SAS va. If the user does not select any filters the column should show overall expratio, if he selects particular state it should show expratio of that particular state.If they select state and city it should show accordingly. Thanks, Harsh Patel
... View more