We cannot extract multiple rows while performing a Drill down from a Pie chart or Column chart etc directly.We need to apply a simple trick.
Please find below steps to perform a multiple row drill down in SAP Dashboards(Xcelsius).
Data I am using is :
|City||Reading 1||Reading 2||Reading 3|
Requirements – I want to create a Pie chart on city and Temp as per Table 1 and as I click on the pies according to the click data should display on an excel sheet from Table 2.
1.Create the simple Pie chart on the Table 1
2.Now, We have the Pie with 4 Pies as Delhi,Mumbai,Pune and Kolkata
3.Now Create a Combo Box component and select its label as whole city column from Table 2.
4.Put Combo Box’s insertion type as FIltered Rows and select the whole Table 2 (Data Only) as source and corresponding target i.e. same number of rows and column as Table 2.
5.Now, we want to change the Combo Box entry automatically as per our Pie selection, for this go to Pie Chart Insertion Tab and select insertion type as Row.
6. Select the whole Table 1(Data Only) as source and one row with two columns as Target, now as user will select a Pie corresponding entry will go to Target row.
7. Go to Combobox – Behavior tab and map the Selected Item as Label and map it to the Target row (Column – city) of Pie Chart Insertion which gives us the CIty
8. Now, take a spreadsheet component and map its display data as the Target of Combo Box.
9. Also hide the Combo Box from user, so that user will get a feel of drilling data from pie chart only.
10.Please find attached sample xlf of the above example.Kindly extract the zip and change the file extension to XLF.