This can be done by creating a calculation similar to the following:
lookup(sum([Order Quantity]), first())/lookup(sum([Order Quantity]), first()+1)
Place the calculation on the view. Then, right click on it and select Compute Using-->Pane (Down).
Hope this helps!
Unfortunately that is not working. It is giving me a bunch of 0's and 1's.
It should be as simple as
countd([Problem Type] = 'Other') / countd ([Problem Type] = 'Non-Other') but that just gives me 1's.
I'm so confused . . .
1 of 1 people found this helpful
My guess is that you need to change the number format of the calculation so that it shows up as a decimal or percentage. Right click on the calculation in the data box and select Field Properties-->Number Format-->Percentage. Hopefully this will give you the desired results!