Comments
-
I got the error message I dislike most of all LOL: "This calculation uses both aggregated and non-aggregated columns. This may result in duplicate rows and unexpected behavior in charts. See this article for more information." any ideas how to tweak with an aggregation function?
-
Unfortunately the result was the same. First image is with neither selected, second is with just brand. Each row is a brand/cat/demo group.
-
Looks like I'm up against another challenge - while in Analyzer I click preview and it fails with this error after a few minutes - An issue has occurred during processing. We are unable to complete the request at this time I'm guessing its the size of my datasaet - it's about 1.2B rows, though must metrics don't seem to…
-
Thank you both -@ArborRose that's essentially what I did and I temporarily solved my problem by flipping the pivot and making the Retailers static. @DavidChurchman I wasn't aware of the emoji's - I'm going to play around with it as it might be a better long term solution. Thank you both!