see attached red tab
I rebuilt the "Not working" solution from scratch - and it worked
Dont know what to tell you except I have used that same solutio a number of times and it is very "process fussy"
It needs to be built is a specific order - if you open the individual nested table calculations and check the details
the levels are a build up of the calculations that preceded them (if that makes sense ) so if the built up is different you affect the nested calculation
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.
I'm not sure what I was doing wrong yesterday. Maybe I had just spent so much time working on it, that I kept repeating a simple mistake.
Everything is working fine now. Hah...
Thanks for the response!
1 of 1 people found this helpful
it has everything to do with the order you used to create the viz and the setting of the calculated field sequence -
you need to start placing the deepest level first and build to the broadest level
glad to help
glad to help out