0

GroupBy Formula in Pivots

Can you use GroupBy in Pivot Tables in addition to Aggregated Tables? If yes, then what would the structure be if you are wanting to group by your dimensions in the row and dates on the columns?

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Mark Samuels

     

    are you referring to level-based measures in pivot? 

    Level based measures are not supported with column dimensions, like a pivot table. It works fine with aggregated tables.

     

    see like examples below.

    sum(

        SALES.SALES.COST_OF_GOODS,

        groupBy(

            SALES.PRODUCTS.PROD_SUBCATEGORY,

            SALES.PRODUCTS.PROD_NAME

        )

    )

    sum(

        SALES.SALES.COST_OF_GOODS,

        groupBy(

            SALES.PRODUCTS.PROD_SUBCATEGORY

        )

    )

    Like
Like Follow
  • 2 wk agoLast active
  • 1Replies
  • 17Views
  • 2 Following