I have a matrix with two levels of grouping in columns (month and day) and one for rows (product), and a measure (sales)
The second column group is hidden, but becomes visible when you open a drop-down from the first group.
I want the total of each month without displaying either the last value of the last day of each month, and then I added a subtotal to the 'month level', and I want the data to appear here is also the last value of the last day of last month . it was similar like a lastvalue.
any idea in calculated formula?