Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

problem with lastvalue in matrix ssrs Expand / Collapse
Posted Tuesday, October 29, 2013 10:18 AM


Group: General Forum Members
Last Login: Tuesday, October 29, 2013 10:13 AM
Points: 12, Visits: 58

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?

Post #1509454
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse