Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to change the values of a field month for the previous month?
AddMonths(YourField, -1)
works only when I select a list, I want to use it in a PivotTable field itself as a dimension month, when I do this, I put in a variable and then in setanalise, it overrides
Try with chart inter record functions like above() and before(), e.g.
=before(sum(Amount))
or
=above(sum(Amount))
Can you post an example?