Forum Discussion

marcus505's avatar
marcus505
Frequent Visitor
7 years ago

subquery

Hi All ...

I have a table with threee drop down fields [Type A,B,C,D] and want to sum by values selected over a period of time - see format shown below. All the three fields are in one table.

I guess i need a subquery or multiple select statement to return each value and then use a Matrix table ? Whats the best approach ?

 

Many Thanks,

Interesting Links
Need Help
Tips and Tricks
Tutorial Requests

3 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi marcus505,

     

    Really sorry for the delay.

     

    Is the image you shared your data sample?

     

    I'm still a little confused about your requirement.

     

    I have a table with threee drop down fields [Type A,B,C,D] and want to sum by values selected over a period of time - see format shown below. All the three fields are in one table.

     

    It seems that you want to sum by values with selceted over a period of time.

     

    Do you want to calculated the values for each type when select the week x in slicer?

     

    I would appreciate it if you could share your expected output so that we could help further on it.

     

    Best  Regards

    Cherry

    • marcus505's avatar
      marcus505
      Frequent Visitor
      7 years ago

      Hi Cherry,

       

      Thank you for your response.

       

      A record has four fields [Type A,B,C,D] with different values to select.

       

      I want to sum by values selected for each record on a weekly basis. Sorry for the confusion

       

      Only one value can be selected per [Type] 

       

      Many Thanks