Set Analysis in a Pivot table - select specific dimension for

[whiteside]

Hello Everyone,

i am trying to divide all numbers (RED) by the number found in week 7 (GREEN):

I thought I could use this to find the value 4754
sum( total {<Week_number  = {'07'}>} [number of shipments])

then I wanted to do sum( [number of shipments]) /sum( total {<Week_number  = {'07'}>} [number of shipments])

but it doesn't work.

please help.

[whiteside]

just for the record:

sum( {<Week_number = {'07'}>} [number of shipments])

doesn't work.

Since its a Pivot table it shows me 0 in all the other weeks and only counts in week 07 for 2022 (4754) and for week 07 in 2023 (4517)

but i want to divide every week by week 07 from 2022 (4754)