Show calculated values from Straight table in Filter Pain

[ashishpalkar]

Hi There

I have following requirement,

I have created straight table in my QS App. In one column I am calculating values like below

(FABS((Column(1) - Column(2))/Column(2)))*100. The values are coming correct.

Now what I am trying to do , create "filter pane" and show all values which are derived from above formula.

Please find attached screenshot.

Thanks in advance.

[jaimeaguilar]

Hi,

it does not work like that. The column() function only works within the object (table, chart). If you need to use the same formula outside the table/chart, then you need to use the complete expression,

hope this helps,

regards

[ashishpalkar]

Hi

Thanks for your reply, I am using variables instead of column () function. This is just example .

My question is how can we use measure in the filter pain.

this is my actual formula - >  (FABS(($(Sales1) - $(Rev2))/$(Rev2)))*100

Thanks again.

[OmarBenSalem]

filter pane is a dimension; not a measure; this is why you're not getting any result; u need to aggregate it with sthing :

aggr( yourMeasure ,aDimension)

[ashishpalkar]

Thanks Omar

How ever I am getting only one value in the list when use this

aggr( yourMeasure ,aDimension)

[OmarBenSalem · Accepted solution]

Not the case for me:

try to aggregate by the dimension of your table; Product I think