Thank you @Sumanth V -Oracle The issue lies with the join used (though there are no duplicates). I removed all columns and left only the two but still got incorrect value. Then I changed to FULL OUTER join and the result is correct (LEFT, RIGHT and INNER were all giving different wrong results). I thought the calculations'…

Hi @Gianni Ceresa In the case where I am using Oracle Analytics Server, where is the log file located? Thank you.

Hi @Philippe Lions-Oracle Thank you for your assistance. The sort was already in place (High to Low), so only option is to Clear Sorts, whose net effect is just that. No change in the horizontal bars. I will just have to change the viz. Thank you.

Hi @BalagurunathanBagavathy-Oracle Thank you for your response but still not working.

Thank you very much @Nathan CCC . Will do.

@Nathan CCC I would like to delve more into the row level security you have mentioned above. Are you in a position to assist?

Yes @Mostafa Morsy-Oracle, it works perfectly in my case. Thank you.

My apologies for my explanation not being clear enough. Thank you @GayathriAnand-Oracle. Thank you @Mostafa Morsy-Oracle , your calculation works. Its what I was looking for.

Thank you @Sumanth V -Oracle Actually, the calculation is simple - Get the number (count) of customers who have an order amount of zero from the given table. If I use a Table visual, I am able to show all customers and their order amounts, and if I apply the filter "ORDER AMOUNT = 0", I can display only the customers with…

Thank you @Mostafa Morsy-Oracle Do you mean something like this:

Thank you for your responses. @Christian Berg The count, if I was to put it in a sql statement, would be: SELECT COUNT("CUSTOMER ID") FROM TABLE WHERE "ORDER AMOUNT" =0; I would expect the result to be 3, but in this case 'No Data Found'.