Hi I would like to see your twbx workbook with the data attached -
see the attached superstore examples
they return this
the running totals formulas look like this
then you can divide them like this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
divide running totals.twbx 2.4 MB
Looks like if I directly write [running total count orders] / [running total cat], there's an error. While if I write running_sum(COUNTD([Order ID]) / running_sum(COUNTD([Category]), the ratio are all equal to 1, which is not as expeceted. I'm not sure if it is affected by column field Month(xxx)?