1 Reply Latest reply: Oct 1, 2015 1:58 AM by Gysbert Wassenaar RSS

    Ignoring selections on Dimensions

    Cl�udio Vaz

      Hi,

      Ive been trying to create a bar char where can user all the Years as Dimensions.

      The thing is need the dimensions to ignore the selections because the last year is all-ready selected.

       

      I need the Year to be in the dimension because it has to Stacked with other dimension (local Delivery).

       

      As i need all years (Distinct years i mean) to appear in the Dimension i cant use something like sum({1}year) to ignore the selections.

       

      I will attach picture of the result i would like to get (but in this case with the Year Clean)

       

      Can anyone help me with this?