Optional Expressions?

[bdunphy]

Hi,

I have a pivot table  with 3 expressions.

1) FCast/Actual

2) Prior Year

3) Budget

However not all users need to see all 3 expressions  at all times. Sometimes they will only want to see the FCast/Actual - other  times they would like to see two expressions.

Is it possible to  allow the user to decide what expresssions he/she wants to see?

e.g. only show the  FCast/Actual initially and then allow then to select to see the Budget and Prior  year too if necessary

If its not possible at the moment - is it something that is planned in version 11?

Thanks

[#2]

Any ideas? I think I'm going around in circles.

[isaiah82]

Check out the attached as an example (QV11 only) using a control table to select which columns to show.  Focus less on the data and more on how I accomplished the dynamic columnns.

[#4]

Thanks Isiah. This works like a charm.

[#5]

Hi Phani,

I like your solution.

Is there a way to use an expression like this in the script editor, when you create the inline table:

=Avg({$<Institution= p(Institution2) >} [Actual value])

I tried this :

Metric:

replace LOAD recno() as MetricSequence,* INLINE [

Metric, Expression

  Average, "AVG({$<Institution={'*'}>}[Actual value])"

  "Peer Group", "Avg({$<Institution= p(Institution2) >} [Actual value])"

];

but it give an error, probably because of the symbols.

Is it possible to have an expression like this in the inline table?

Thanks

[phaneendra_kunc]

Yes you can write these type of expressions, but not in inline statements.

1.) you can load it from Excel

2.) if you are not using reduce and Reload concept, you can write it in the Grid it self.

          a) Edit script

Metric table:

LOAD * INLINE [

Metric, SeqID

Average ,1

Peer Group,2

];

          b.) Front end:

Write below this as your expression

pick(SeqID,AVG({$<Institution={'*'}>}[Actual value]),Avg({$<Institution= p(Institution2) >} [Actual value]))

          c.) Add Metric as Dimension

          d.) Also add Metic as Selector (list box or Multi Box)

Thanks,

Phani

[phaneendra_kunc]

Yes you can write these type of expressions, but not in inline statements.

1.) you can load it from Excel

2.) if you are not using reduce and Reload concept, you can write it in the Grid it self.

          a) Edit script

Metric table:

LOAD * INLINE [

Metric, SeqID

Average ,1

Peer Group,2

];

          b.) Front end:

Write below this as your expression

pick(SeqID,AVG({$<Institution={'*'}>}[Actual value]),Avg({$<Institution= p(Institution2) >} [Actual value]))

          c.) Add Metric as Dimension

          d.) Also add Metic as Selector (list box or Multi Box)

Thanks,

Phani

[#8]

This is a really great example - thanks!!