ContributionsMost RecentNewest TopicsMost LikesSolutionsRe: RSUM ON DAYS WITH 0 DAILY VALUE Hi cartercjb , Can you share the formula screenshot, that you are using in the Formula/Value section of Pivot. It should work if you use normal Rsum. Thanks Ayantek Re: Using a dashboard multi-tenant? HI, We could able to achieve this when we maintain some table & Column names or the same schema across tenants. Ayantek Re: Pivot conditional coloring based on time Hi rahuldhomane , In the values section, there will be a color palate icon beside the toggle button, when we click on that it will open a window where we can give conditional coloring. I have attached a sample example, hope this helps. Thanks Ayantek Re: Formula for count with filter Hi Akhila , Please right-click on the dimension which is "age filed filter by value between 20 to 40" in your case and filter out which value you are looking for, attached screenshot for your reference. (count([Brand ID]),[Age Range1]) Ayantek. Re: Using answer to a calculation within another calculation Hi CLewis , I have faced a similar kind of use case to bring count and sum excluding a category in the pivot. Below is the analysis: For SUM its a straightforward with ALL function but for count, we need to check for all the filters we added in both the widgets, attaching a few screenshots for your reference. this is the formula I used to get %percentage (([# of unique Brand ID],All([Gender]))/([# of unique Visit ID],All([Gender]))) In your case, you need to add JobID in All(JobID) both in numerator and denominator. Hope this helps. Ayantek.