Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to eliminate or remove rows from the straight table based on if condition. I have tried applying the calculated dimension but it did not work as expected. So i applied the if condition to all the expressions. It is working fine.
Now I am facing issue to get the total of each column,Expression-> sum of rows does it but there are some expressions which are calculating percentage. What should i implement in order to calculate percentage.
So could please help me with this issue. Thanks in advance.
Regards,
Akshay
Hi Akshay Netalkar,
If you can attach your sample work, community might be able to help you much faster.
Please upload sample qvw?
I have attached a screenshot of the straight table
Here in this straight table should contain only those distributors where the Achieved forecast is positive.
Similarly there is another chart where only negative values should be visible.
So I have applied a if condition present in a variable and applied it on every expression to decide if the value is positive. Similarly for the other chart having negative values.
In the present if condition i.e if($(abc)>=0,Expression,0) similarly for negative values if($(abc)<0,Expression,0)
But when I trying to calculate the percentage as marked in the screen shot the value is 0. Rest of the columns are managed using sum of rows.
Could you please help me with the filter so that I can calculate the percentage or any other way to show percentage using current if condition.
Try Expression Total
Did you try to use the dimensionality() function?
grtz
Hi,
Can I ask how many dimensions are in your straight table?
Well I think you can do something like this
Sum( TOTAL <Dim1,Dim2> SalesFigure)
This will give you the total. Please note that the Dim1,Dim2 is just my assumption. So if you only have 1 dimension then you only need 1 dimension in the expression.
Hopefully this answers your question
Hi
You need an Aggr() expression like this:
Sum(Aggr(<current column expression>, <dim1, dim2, ...>))
Where
HTH
Jonathan