14 Replies Latest reply: Oct 7, 2015 10:04 AM by Piet Hein van der Stigchel RSS

    Set Analysis ignore not working?

    Neal Bouwman

      Hi All,

       

      Maybe I am missing something obvious but I have been looking for a while without finding a satisfying explanation.

      I have a pivot table with 2 dimensions (1 calculated) and an expression. The expression and calculated dimension both use set analysis ignoring field A (using field A=). But for some reason when I select a value in listbox list A, the values still change. Why..?

       

      Any ideas?