Hi All- Can some one please help with this issue I am facing. when we use the week ending date and date in a worksheet the measure is showing up correct information.
but, when i remove the day from the view, the grand total started messing up and it's not saame for the week.
screenshot attached. all i need is that I don't need day in a view of the work sheet. just weekending date and measure. how can i achieve this?
both screenshot and twbx attached with this case.