user069636 Member

I applied the filter for yesterday to see if my beast mode calculation for revenue yesterday was the same as the Revenue data from the dataset. It turns out that there was an issue with my dataset. It is now resolved now. Thank you for your comments!

@MarkSnodgrass It worked. Thank you very much!

@GrantSmith That's good to know. Thank you for your help!

I cant use that as a filter because 'PW Sales' contains uses aggregated function. 😭

@GrantSmith I have tried sorting for both the old one and the new one but they are still showing on the top.

Hi @GrantSmith, With your recommendation, I was able to remove the ranking numbers for the categories that had null values. But they are still on the top of the table. I cant filter out records with null values because the aggregation isn't supported in filters.

@jaeW_at_Onyx I was able to get to that part, but I am unsure how to create rows like Gross profit, where the calculation is not just sum, but subtraction of sum of cogs from sum of sales. Is there a way for me to create those different calculations for gross profit, operating income, income before taxes?

@GrantSmith It looks like the Group By function drops all other columns not being used. Is there a way to still have the unused columns after grouping by? 

That makes sense! Thank you so much!