The sheet goes to null because there is no data with ch of something other than 1 and a cl of partner 3. With cl set to all I get data in the dashboard
Thanks for the reply.
I am having problems with calculated fields not filtering in the actual business scenario. Please help with proper way to filter the values
Can you replicate your problem with the example data set above? If not, you need to post a new data set that does have the problem.