Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Not the case for me:
try to aggregate by the dimension of your table; Product I think
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
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.
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)
Thanks Omar
How ever I am getting only one value in the list when use this
aggr( yourMeasure ,aDimension)
Not the case for me:
try to aggregate by the dimension of your table; Product I think