How to show different groups in same matrix where no parent or child relationship

Caroline Allen

I am tasked with reproducing a spreadsheet in an SSRS report to save hours of Excel spreadsheet work. I have done all the calculations and got them into a single dataset however I am not able to work out how to display in the same table/matrix. My spreadsheet looks like this:

spreadsheet

Column B is a text column used to describe what the figures in each group are showing. Col C is 'Region' grouping.

I have got this far with my matrix - grouping by region and month. This gives me rows 3 to 8 incl of the spreadsheet.

design view

But I am not able to work out how to add the next group of data (rows 9 to 12 in the spreadsheet) into the matrix. Each group of figures would use an expression to pull by a different field so only using single dataset: I still want it to use the region and month exactly the same as the top group. There is no parent or child relationship between the labels in col B in the spreadsheet.

I have tried adding an adjacent group below but it is still trying to keep it as part of the top group.

Is this at all possible?
do I need to have 6 different matrix, placing them together and just hide the month names in the bottom 5?

This is an extract of the data results. The top group counts the uniques customer id, the second group counts the unique sale id, the 3rd group totals the net sale value, the 4th group totals the profit value, the 5th group calculates the total sales and divides by the number of customers, the 6th group calculates the total sales and divides by the number of sales.

query results

SuperSimmer 44

It looks like you will have to have 6 separate tablix and amend the aggregate function and field for each tablix

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

Django how to show all comment as child parent relationship in HTML template?

How to specify different resources in a child/parent relationship in an Azure ARM template?

How to use different instances of service without parent-child relationship?

JQuery Datatable with parent child relationship in same dataset. How to display it as parent child rows in the table?

Where is the parent/child relationship stored in Hibernate?

Display child and parent relationship (if any) in a same table

Laravel parent / child relationship on the same model

Eloquent Parent-Child relationship on same model

How to Unmarshaller XML by JAXB where parent and child node as same name

How to show child of parent in template?

In graphql schema, how can I create a parent/child relationship of same model?

How to deal with Parent/Child/GrandChild relationship?

How to build Parent and child relationship on JAXRS

How to check if a parent/child relationship exists in a tree?

How to Set a Child to Parent Relationship in Visio?

Unlimited Hierarchical child parent relationship in the same table using JPA (TreeView)

How to apply Eloquent where() to child in hasMany() relationship

Recursive Parent/Child in same table query in SQL where parent is PK

Parent and child css relationship?

Parent child relationship - TSQL

Parent and child relationship not working

XMLUnit compare XML not working where parent node contains multiple child nodes of same name and attributes list but different attribute values

SQL QUERY - how to get child records with different types but from the same parent group

All groups in same parent

Using CSS, how to modify a child element by its class without impacting another child element with the same class but slightly different parent

Join foreign key on the same table and show parent and child

Parent with a child in the same type - how to map it?

How prevent retrieve a child in same parent node?

How to display all parent and child groups in one column in rdlc