12 Replies Latest reply: Sep 29, 2018 1:15 PM by Stefan Wühl RSS

    Using total in a pivot table

    Daniel Rodríguez

      Hi all

       

      I have the following issue I don't know how to solve it:

       

      I've created one fact table with two kind of data using concatenate. Most of the columns are in both subset but there is one that is only in one subset (Let's say variable A only exists in type A).

       

      I want to create the following table:

       

      Captura.PNG

       

      The problem I see is that if I have let's say 20 variables in common and I want to put all of them in the pivot table I have to write the following code:

       

      sum({<tipo={'TypeB'},VariableA=>} Total <Year,Year-Month,Variable B,Variable C,Variable D,Variable E......> total)

       

      Is there another way to do that?

       

      Thanks you!