SSRS Keep grouping but merge data values
I have an SSRS report that contains 4 columns: Customer, Postcode, Date and Value. Customer, Postcode and Date are my groups and Value is my data.
I want to end up with something that looks like the image below:
e.g. Customer A ordered £50 on 01/01/2024, £30 on 02/01/2024 and £20 on 03/04/2024, so has a total of £100. This is what I want to show, not the individual £50, £30, and £20.
I know how to get Customer and Postcode to appear every row (rather than merged because of the grouping), however I'm not sure how (or even if there's a way) to merge the overall value for Customer. Any help is appreciated :)
As you only need grouping at one end of the tablix then you can do this. It's not very intuitive but it's simple.
Create a table and add Date, PostCode and Customer in that order. Then add a parent group that groups by customer. This will add a group column at the start with the customer field already in place, change this to use the value column (so the expression will be =SUM(Fields!Value.Value) and adjust the header accordingly.
Finally, on the tablix properties, chenge the LayoutDirection property from LTR to RTL.
Here's a quick GIF to show you how I did it. (open in new tab to see it larger if required)
- Reducing memory use in grid movement combinatorics
- Unity3D MultiplyPoint matrix confusion
- How to input matrix (2D list) in Python?
- How apply a function to every element of a matrix?
- Why does a Maxtrix rotation produce "wrong" extents and how do I fix these?
- How to efficiently assemble a FEM sparse matrix
- Efficient connected components from a 2D array
- Create an object class matrix/array from data frame
- Rotation of a 2D array over an angle using rotation matrix
- Transforming strings into n * n ascii value matrix
- DFS-compatible coordinate-free neighbors in Haskell
- Get x or y distance between 2 items in a 2D array[,] of any type not knowing the index of either items and edit items in between
- Lower triangular matrix in julia
- Change the matrix values using index vector
- A Cache Efficient Matrix Transpose Program?
- Excel Matrix - Formula or Function to Determine Upper and Lower Triangular Sums
- How to combine multiple row vectors into a single row vector using loop?
- Display matrix with row and column labels
- How do I multiply elements using conditional statement?
- Projection matrix causes vertical offset
- Why is matrix multiplication with MathNet.Numerics slower than regular multiplication?
- Find the maximum element of the matrix and delete a row with this element
- in android canvas why the matrix is too slow and sluggish
- Using a for loop to Print and Two-Dimensional Array in Java
- Global matrix doesn't return the right value when read
- How to calculate matrix determinant? n*n or just 5*5
- Using spfun with two identically ordered sparse matrices
- Create clusters using correlation matrix in Python
- Numpy element-wise addition with multiple arrays
- How do I shuffle a specific 2D cell along the z-axis in a numpy 3D matrix?