Hi Experts, I m trying to get 3 months figure in a column of a straight table. the dimensions in my table include date field. in my expression, i have to calculate the data received for 3 months from the selected month i.e, if i select January, my expression should calculate data received for Jan, Dec & Nov. my expression is in attachment. when i entered this expression and selected January, i m getting correct value in the expression but, my dimension date is showing date from november which is wrong. i just need the selected months' date to be displaying in the dimension. how can i do that. please help
unfortunately i dont know details of your usecase or data model. also if you go through the link you will see that possibly best option maybe a asof table which is a change in the data load script
