Hi everyone, i have a requirement i.e if i select any value in areport filter for week example 45, then report has to show data upto 44th week only.
for this i tried the following query. here i can only give a fixed value.
if i change 19 value to any number(example 33) it will give me upto 32nd week.
but what i need is , it should be dynamic.
can anybody have any idea on this please help in this.
select
subset({
[Date DIM].[ISO Week Short FI].members }, 0,19)
on rows,
{[Measures].[B2B sales with tax] }on columns
from [POS OLAP Daily Material Sales]
thanks in advance
Niharika