Display Data

[Amina]

Hello,

How can I get the Tab2 as a result please and knowing that the reduction is not a measure.

Tab1:

Date	Product	Discount
26/03/2024	Item	10%
02/04/2024	Item	15%

Tab2:

Product	Week 13	Week 14
Item	10%	15%

[Vegar · Accepted solution]

If you are not dependent on making filters on discount value then consider making a pivot table consisting of the dimensions Product  and Week in combination with the  measure =Only(Discount)

If thats not applicable for you, then you might have a look at the generic load blog poat by HIC.

[Amina]

Thank you for your reply