Calculated Dimension

[ecabanas]

Hi,

I have a table that calculates the total orders. The dimension is week, but unfortunately I have a problem. For present year the calculationare ok, but there are some orders made last week of 2014 that was the first of 2015, and in the table appears weeks from 1 to 30 and data from 51 week!

I wold like to fix this issue doing a calculated dimension that has a conditional: only shows weeks lower than present week.

Any idea?

Many thank's guys

Eduard

[sasiparupudi1]

Please post some sample data or application

[ecabanas]

See attached the !qvw

Thanks

[Kushal_Chawda · Accepted solution]

Either you create Week using LunarWeekName fuction  or use calculated dimension as below

=if(date_Week<= week(Today()),date_Week)