<<root.Header>> is the business column not the physical column. when i use the physical column, it works fine. when i say put(<<root.Header>>, 30.) = "overall" it gives an error... ... View more

u answered my question. yes, this is what i meant. thanks. another question, can i do conditional formatting on on measure value based on category value...so if region = 'a' then measure color = red, else measure color is green ... View more

basically i have 4 dimensions, it works fine if i use all 4 dimensions, but if i use 2, when calculating net migrations, its not able to rollup properly ... View more