Forum Discussion
UrAvgWally
Helper I
Helper Ihow to Sum between two columns dynamically
Hi all, I was trying to figure out a measure which will be able to sum between two columns which are variable. For example I have a report which columns are Period 1, Period 2, Period 3, Period 4.....
UrAvgWallyHelper I
Helper IHiya tamerj1 !
Thank you for your time!
I unpivoted those periods, but it makes columns like COWD repeat itself. Which will make my other calculations harder. For example I planned on doing sum(Cowd)-sum(Forecast) to get variances. But since this duplicates the figures, would not be able to do so easily. Is there a way to unpivot to a seperate query just that extract?Also after unpivoting , what steps should be used to get my desired output of adding between two variable periods :)?