Pivot Table to Chart

[Anonymous]

Is it possible to convert this Pivot table (See screenshot below) to a chart?

Dimensions:

State

EndDate_YYYYMM

Expressions:

Count({<[ENDDATE_YYYY] -= {"3000"}>}ID)

If(RowNo() <= 3, Num(Count({<[ENDDATE_YYYY] -= {"3000"}>}ID)/

Below(Count({<[ENDDATE_YYYY] -= {"3000"}>}ID), 1) - 1, '#.00%'))

[sunny_talwar]

Pivot table to a chart? Pivot table is also a chart... what exactly do you mean?

[Anonymous]

I would like to turn the pivot table into a bar chart but I have multiple dimensions (State and EndDate) and I'm not sure if that's possible.

[sunny_talwar]

May be this:

Aggr(

     If(RowNo() <= 3, Num(Count({<[ENDDATE_YYYY] -= {"3000"}>}ID)/

     Below(Count({<[ENDDATE_YYYY] -= {"3000"}>}ID), 1) - 1, '#.00%'))

, State, EndDate_YYYYMM)

[MK9885]

Do you mean by 'Fast Change'?

Same chart but different views?