Page 1 of 1

Understand CAFE

Posted: Thu Nov 06, 2014 10:23 pm
by hyunjia
Hi , this may be a silly question , but I am new to the CAFE . Just wondering how I could distinguish the cell which is driven by CAFE and which is not ? :oops:
As I am aware , when I drag and drop the crosstab to a worksheet , you could directly update those cell without formula like it did in pespective .

Re: Understand CAFE

Posted: Thu Nov 06, 2014 10:37 pm
by RJ!
Once you drag a cell away from the cross tab it's going to be nigh impossible unless you change part of the filters etc.

I'd recomend colour coding any cells that are driven by CAFE for ease of review/audit. That way when you move them, it's easier to know what is linked.