I have an expression to accumulate a count using RangeSum and Above. The issue is that when I add a dimension it no longer performs the RangeSum and Above. I can see why it does not work as when i create a pivot table using the same logic, it does not accumulate the value as it now needs to sum from the right not above. I have trolled through the community but no one seems to have something similar. What am i missing?
Which way are you trying to accumulate? Going down or going across? For going across you need to use Before()/After() functions instead of Above()/Below() functions and use ColumnNo() instead of RowNo() function
So I can now get the Pivot table working correctly but when I use the same logic in the line chart I get nothing. What frustrates me with this program is if you can do something in a pivot table why cant one use the same logic for a chart? Too often, I need to adapt the expression again. What is the logic behind this?
You might see it as restrictive and frustrating, but I see it as making it more intuitive for developers. If you look at this in a pivot table, If you want to accumulate horizontally, would you say that you would want to go above or below? or would saying After and Before would make more sense? Similarly, it is the same logic for ColumnNo() vs RowNo().
To differentiate, pivot table is an exception where After/Before and ColumnNo, else all other objects will need Above/Below and RowNo(). If you really hate After/Before and would like to use Above/Below for even a pivoted dimension of a pivot table, you can use it with Aggr(). Because when you use Aggr(), the imaginary table which it creates is similar to a straight table, the Before/After function stops working. So, now you can use Above/Below.
Hi, I really appreciate this as coming from an excel background is different to a developer. However, how do I get my line chart to function correctly though? I used the above and it does not show the expected result like the pivot table.