Thank you Chris Thanks for your reply. Seems like yours and joels approach are same I tried this way already and I was getting all zeros for the result column and so I tried creating a calculated field in the pivot table. I have the metrics count(distinct customer),count(distinct products) for each union which I wrote in…

Hello Joel Thanks for your reply. I tried this way already and I was getting all zeros for the result column and so I tried creating a calculated field in the pivot table. I have the metrics count(distinct customer),count(distinct products) for each union which I wrote in the column formuale. I tried to follow this blog…

Hello Chris, I hope you did not read my question .I created a pivot table based on Union query and I want apply formatting on Calculated metric Thanks DNK

Hello Joel, Can you explain conditional formatting on the result column?? I created a calculated Item for Ratio($1/$2) I need to apply the conditional formatting for that field. Thanks DNK