Wondering if you can help me. I have a Grid Chart showing a count of requests, this has two dimensions. One is order type and the other is Delivery date.
I want to create a Grid Chart showing the percentages, with each order type, for the delivery dates. I have tried using the relative button but this uses percentages across all types. I want each order type row to add up to 100%.
I'm also using an IF statement within the expression as I'm only interested in orders created in the last week.
My expression is below :
=NUM(count(IF([Order Date]>(today(1)-8) AND [OrderDate]<(today(1)),[Order No])) / count(total IF([Order Date]>(today(1)-8) AND [Order Date]<(today(1)),[Order No]))*100,'##.##')