subquery

[marcus505]

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,

[v-piga-msft]

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]

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

[marcus505]

any ideas - is this possible ?