As shown in the screenshot, Can someone please confirm how percentage change (Red/Green) can be shown?
Is it separate sheet required to show +/- numbers or possible in the same sheet?
Basically there will be parameter selection provided to select period YTD/QTD/MTD etc and percentage change needs to be shown compared to previous period. I feel if parameter control is selected YTD then percentage difference wont be calculated correctly as Previous YTD amount wont' get populated so separate sheet needed.
Please provide your inputs.