Good day,
I created a cross tab report based on Business ID, BYM, and $ (6 different measures from 2 classes within the same universe). It has one prompt on BYM (between).
For some strange reason, when I utilize the Business ID object, it returns the same values for all six $ columns. I'm not quite sure if this is the place for this question, but if anyone can tell me how to fix this I would greatly appreciate it.
A colleague asked the following question. "Do you think it could be a problem because the business id is part of the data record instead of it being in a separate table?" I'm not sure if it's relevant.
Has anyone experienced this before?
scratching head
W.