Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have attached the QVW. When I do the sum it only display the sum of positive numbers and ignores the negative in the top.
Ex ABC - Instead of 500 , how can I show 200 at the top of bar chart.
Thank you.
some thing like this ?
Hello Ansh,
Trust that you are doing great!
As a work around we can fix this by following given steps:
1. Go to the dimension tab and keep on Address in Used Dimension list.
2. Remove existing expression and add below expressions;
//Rent
Sum({<Type={'Rent'}>}Amount) + Sum({<Type={'NonRent'}>}Amount)
//NonRent
Sum({<Type={'NonRent'}>}Amount)
Also refer the sample application attached herewith.
Regards!
Rahul
I dont think I can do Rent + Non rent in frist expression as it show 200 for Rent when you hover over which is not correct.
Rent is 500
Non-Rent is -300
So total expense is 200 which should be on the top of the bar.
Thank you.
I am looking for a stacked bar with Type as another dimension and when I add Type it doesn't add the negative number.
Am not sure if that possible, You have to choose another way of representing your data