Table with Dynamic Rows - One row can show under it two rows?

[KyJoLe]

About: I'm using a similar use-case to keep anonymity. But let's say I work at a car rental company and I have a dashboard that visualizes/analyzes various data points surrounding the rental cars, their trips, their cost, etc.

Issue: In one of our tabs I would like to summarize all the rentals cars in a single summary table. Each table row would represent one car. However, given a car will likely have multiple trips I would like, upon hover or click of the car/row, additional rows to temporarily appear under that car/row that gives details around each trip. This will keep the view minimal as there may be 100 cars but 1000s of trips. Essentially I'm giving management the summarized, hard hitting, information and if they so choose to, they can also see the granular detail that make this up.

Question: Is this possible?

Example:

When you either hover, or click, on the Toyota Tundra line it would show the three lines under it.

Make	Model	Year	Miles	Cost	Revenue
Toyota	Prius	2020	50,750	$30,225	$55,750
Toyota	Tundra	2023	35,000	$40,500	$32,750
		2023	15,500	$1,250	$10,500
		2024	10,500	$1,550	$15,250
		2025	9,000	$175	$7,000
Toyota	Prius	2024	28,220	$35,025	$15,750

[JHuis]

i would make the dimensions who you want to hide first with conditonal hiding 

and you could do getselectedcount(Make)>0

I hope this helps?

[marcus_sommer]

Using a pivot-chart should provide the described functionality. 

[gomeri]

Hi @KyJoLe,

if the goal is for one's management to see summary insights, the pivot table is the best solution because it allows one to indent dimensions within other dimensions (as shown in the image). Click on the “+” symbol to see the total sum of “Revenue” based on the selected category. Clicking on the “-” symbol allows the total “Revenue” to be reduced to a higher level dimension (the sum of the sub-dimensions that make up the outermost dimension).

Otherwise, if you want a much more eye-catching visualization it is possible to create a “Drill-down” dimension with, e.g., a bar graph,“ in which you then click on a particular generic segment and enter ”drill-down" to the displayed information.

Let us know if the answer was helpful to you.

Thank you