Straight table alternate state column help needed.
Hi, I need to make a calculated dimension to follow values in one state and another to follow values in another state to make side-by-side comparison in a straight table but not sure about syntax.
I have regular fields like clientname, userid, testname, testvalue and testdate for dimensions. I used a simple count formula as the expression for now. I need to make testvalue and testdate columns to follow Cohort1 alternate state, and another pair of the same columns to follow Cohort2 alternate state in a straight table. I have the listboxes made for each state.
(I might be able to wing this in a lumpy expanded pivot table or two straight tables patched together in excel, but would like to try the alternate states set analysis approach here.)
