i have a data that the based on a interval report and i need to ensure that the results monthly weekly. The challenge is that the table created is based on average and therefore does not weight the results. This creates a problem when we validate the information on the monthly tables.
i have tried use the "Only" script but this will not give any results. The purpose of the model is have a drill down into the model for analysis purposes.
expression is !only(Svl)
i have attached the model and need assistance of tweaking this model to give the desired results.