8 Replies Latest reply: Oct 27, 2014 3:13 AM by Enrique Colomer RSS

    A problem with a pivot

    Enrique Colomer

      I have a bar chart with two dimensions and an expression,


      I want to present the data (Graphic) in two groups according to the possible values of the variable "Grupo" as seen in the figure, but in each of the groups if there are 3 blocks have values and 3 others  have no value because are of other group.  See pivot table (no graphic)


      As I can do to make each group values appear only if the blocks have value?

      The areas marked in red on the chart, I want to disappear.

      Thanks for your help