3 Replies Latest reply on Jan 30, 2018 3:43 AM by Simon Runc

    Query related to Dimensions

    Shruthi B S

      Hi People,

       

      I'm stuck with my current project, wherein i have to get output from multiple dimensions. I have tried to replicate the dataset and connected to it in attached workbook.

      Ask is something like this, I want to count the Ticket ID where HD Ticket="No" for different types of Ticket. But my Type of tickets ie., Type A, Type B, Type C & Type D are different dimensions.

       

      Output required is as below. I want the count of Ticket IDs for diff types where HD Ticket="No"

       

       

      Can someone help. As my Ticket Types are different dimension here I'm stuck .

       

      Regards,

      Shruthi