Show group in the order - Pixel perfect report

Q&A
, , , , ,
1

Hi,
I have the data with below hierarchy:
Region > State > City
How do I paginate to show data like this:

Region 1: showing details of sale of region 1

‘CA’ state: showing details of sale of state CA

‘Los Angeles’ city: showing details of sale of the city Los Angeles
‘San Diego’ city: showing details of sale of the city San Diego

‘WA’ state: showing details of sale of state WA

‘Seattle’ city: showing details of sale of the city Seattle

Region 2: showing details of sale of region 1

‘GA’ state: showing details of sale of state GA

‘Atlanta’ city: showing details of sale of the city Atlanta

‘NY’ state: showing details of sale of state NY

‘New York’ city: showing details of sale of the city Atlanta

… and so on

The showing order is like the sub group of Crystal Report.

Currently, with section, the report will show the details of all regions and then the details of all states and then city. It’s not what I want.

Is there any way I can use to show the report in the order I need?

2

Hi @baduong ,
in Pixel Perfect report there is a quite new feature that should do the trick.

From a Section element you can define a Repeating option.
As you see here, in this report I’ve created a Repeating by Region, Country and City.

image
image3368×1718 390 KB

Then I’ve created a simple table with some data, and a calculated field with a concat() of the values of the fields Region, Country, City (just to be used as a “title” for each section) and the output is a report like this:

image
image1920×1354 164 KB

And so on for the other combinations, e.g.:

image
image1718×792 116 KB

Is this what are you looking for? :slight_smile:

Have a nice day!
Andrea

3

Thanks for your solution.

The only thing here is Region has its own data, State has its own data and also city.
I mean the report has something like this:

  1. Region “East Coast”
    <The report data of “East Coast”>

    1.1 State “GA”:
    <The report data of “GA”>

    1.1.1 City “Atlanta”:
    <The report data of “Atlanta”>

    …

  2. Region “West Coast”
    <The report data of “West Coast”>

    1.1 State “CA”:
    <The report data of “CA”>

    1.1.1 City “LA”:
    <The report data of “LA”>

Not only showing the report data of city in the order of Region > State as your solution.

4

Hey @baduong

Are you still working on this or were you able to find a solution?

While I think the repeating sections are your best option, to your point there is no hierarchy of nesting functionality within the repeating sections. I think your best option is to adapt @andrepgn’s workaround.

5

I have not found the solution yet. I think group header, footer of the report is the essential thing and QS should have some ways to cover it. This should be feature request

6

Hello @baduong

I will mark this as a feature request for the Quick Sight team.