Skip to Content
0

SAP Xcelcius dashboard - display table as popup from pie/column chart based on selection

Oct 03, 2017 at 03:35 AM

51

avatar image
Former Member

Hi Experts,

I have scenario where user wants to select the chart area and display details dynamically.

Any guidance is appretiated. I checked few vids about the table to chart using popup button but I am not able to figure out the Chart to Table dynamics. I am designing this for first time so little confused.

Scenario

Project---- City----- --Status---- ------------Category

P1 ----------City 1 -----Progress -------------Residential

P2 ---------City 1 ------Progress ------------Commercial

P3 ---------City 2 ------Completed ----------Residential

P4 ---------City 2 -------Progress -------------Residential

P5 -------- City 3 -------Hold -------------------Commercial

P6 ---------City 3 -------Completed -----------Residential

and so on in main sheet; from here I created aggregated view for charts

1> City wise projects count display (pie chart 1)

City -----------------Total

City 1 -----------------2

City 2 -----------------2

City 3 -----------------2

2> Status wise Project count display (Column chart)

Status -------------Total

Progress ------------3

Completed ---------2

Hold -----------------1

Now if user clicks on red section (eg. HOLD) it should show me all the projects in List view based on user selection.

Thanks,

Rahul

pie.jpg (74.3 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers