Can you give an example of the result you would expect with the data above?
The IF [event] = "a" OR [event] = "b" THEN [value] END calc will work inside a SUM() when broken down by the time dimension, so I'm not sure what your goal is. See the attached for an example, using the data table you'd posted.
Thanks a lot for your responses! I think we're on the right track. Jonathan, your workbook seems good, gives me what I want (please see the attached workbook named "what I want"), but when I try to do it in my workbook, it doesn't work.
I think I was able to reproduce the error in my original workbook using the workbook you attached. Here are the steps I follow:
1) Remove the "time" pill from the columns shelf and convert it to Measure
2) Put it back in the columns shelf and put the calculated field "sum of a or b values" into the rows shelf. Next, uncheck "aggregate measures" from the Analysis menu. What you see is the current status of my real workbook. I want to get the value 5 at time instance 1.
3) I try to get back to the working state in our workbook (the one named "what I want" by following these steps: Remove "time" from the columns shelf, convert it to dimension and put it back in. However, it doesn't really change and doesn't give me what we had originally. Please see the other workbook (i.e., "What I don't want") for a demonstration of this.
The reason behind this might be the exact same reason why it doesn't work in my workbook either. Maybe, I am missing something very simple.
Thank you again! I immensely appreciate your help.
1 of 1 people found this helpful
In order to get the view in the workbook "What I Want," Time needs to a remain a dimension and Aggregate Measures needs to be turned on (from the Analysis menu).
Hope this helps!
I think this resolves everything. Thank you so much guys!