Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys!
I guess this is a simple question, but still cant find a solution.
I have a pivot like:
BG | Month1 | Month2 | Month3 | Month4 | Month5 | Month6 | Month7 | Month8 |
BG1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
BG2 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
BG3 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
BG4 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
BG5 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
BG6 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
BG7 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
Need to create one more column with the expr to find difference between months like : Month2-Month1, Month3-Month2, etc.
Any ideas?
If the MonthX columns are 8 different expressions you can add 7 more expressions using the column names: [Month2]-[Month1]. If you have a Month dimension pivotted horizontally and one expression you can try the before() function:
first expression: count(Value)
second expression: count(Value)-before(count(Value))
If the MonthX columns are 8 different expressions you can add 7 more expressions using the column names: [Month2]-[Month1]. If you have a Month dimension pivotted horizontally and one expression you can try the before() function:
first expression: count(Value)
second expression: count(Value)-before(count(Value))
if Month is a dimension try with before(your_month_expression) ot get the "left" month
Hi,
But what if there is two dimension and one expression
for example in above
Dimension 1: Month
Dimension 2: BG
Expression : Sum(Sales)
In that case how we can find difference between two month.
Reason behind asking is I also have similar type of query.
Regards,