Skip to Content

restricted column value in all rows

Aug 16, 2017 at 08:16 AM


avatar image
Former Member

hello all,

may be this is a very simple one, but I am missing the point. is there a way to achieve the following:

I am getting the following in a calculation view.

the CY and the PY values have been defined as Restricted Columns in the aggr node of previous CAV.

I want to achieve in the current view as below:

the CY and PY values in all rows. Is this possible? pls suggest how.

before.png (8.5 kB)
after.png (9.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Shanthi Bhaskar Aug 16, 2017 at 08:52 PM

I guess you need to aggregate the data at Comp code level in another node and then join back to the above node..then write formula,,

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

thanks Shanthi.. i did try this kind of workaround and this worked out.