Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi! How can I interpret graph in this way ?
But not in this way, like it happen now (3 measures added to line chart)
Average 9, Average 6, Average 3 are measures.
Use value list
e.g. dimension
=ValueList('9 Month','6 Month','3 Month')
expression
if (ValueList('9 Month','6 Month','3 Month') = '9 Month',
Avg( {<OrderDate={"<=$(=Max(OrderDate)) >=$(=AddMonths(Max(OrderDate),-9))"}>} LineSalesAmount),
If( ValueList('9 Month','6 Month','3 Month') = '6 Month',
Avg( {<OrderDate={"<=$(=Max(OrderDate)) >=$(=AddMonths(Max(OrderDate),-6))"}>} LineSalesAmount),
Avg( {<OrderDate={"<=$(=Max(OrderDate)) >=$(=AddMonths(Max(OrderDate),-3))"}>} LineSalesAmount)))
check link for some theory
Use value list
e.g. dimension
=ValueList('9 Month','6 Month','3 Month')
expression
if (ValueList('9 Month','6 Month','3 Month') = '9 Month',
Avg( {<OrderDate={"<=$(=Max(OrderDate)) >=$(=AddMonths(Max(OrderDate),-9))"}>} LineSalesAmount),
If( ValueList('9 Month','6 Month','3 Month') = '6 Month',
Avg( {<OrderDate={"<=$(=Max(OrderDate)) >=$(=AddMonths(Max(OrderDate),-6))"}>} LineSalesAmount),
Avg( {<OrderDate={"<=$(=Max(OrderDate)) >=$(=AddMonths(Max(OrderDate),-3))"}>} LineSalesAmount)))
check link for some theory
Thank your for help!
No problems