dylang91 Member

Thank you it worked. I am trying to get a vertical graph to split the by provider "level" I think the formula works but I am still working on my graph

@GrantSmith thank you I didn't know that average will exclude the null.

@GrantSmith thank you I added the Budget as a new label and that did the trick! I kind of realized it when typing my question lol. thanks for bringing more clarification.

I have a question that would like to be answered

@GrantSmith thank you this did the trick ! . I cant mark your answer as resolved :S

@MarkSnodgrass thanks I have never tried the Mega Table before, the percent of total only shows the total per region but not by month over the same region ex Region1 Jan 10 16% Feb 20 33% Mar 30 50% Total Region 1 = 60

@MarkSnodgrass I actually needed to identify how many cases were approved this month, which is why I was struggling, because it would only count the ones that were submitted the same month but not the month that were approved. Thank you! :)

@GrantSmith Thank you so much! It took me a second to unpivot the information but it worked like a charm! I appreciate it!