cancel
Showing results for 
Search instead for 
Did you mean: 

Duplicate Records in Tableview Output of BWReport

Former Member
0 Kudos

Hi,

I am calling a Query from visual composer and the output is shown as Table. I have three different project numbers displayed in the output which repeat multiple times. Is there a way where I can show these three project numbers only once and after clicking the project number the respective rows should be displayed.

The current display is as below

Project Number Days

-


Project1 10

Project1 20

Project2 30

Project3 50

The expected display is as below

Project Number Days

-


Project1 10 (on click on project1, i want all project1 related fields)

Project2 30

Project3 50

Regards,

Sreeram

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Drill down:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/b0127853-23a2-2910-30ad-c1873643...

Also please tell us, what data service you use, because with a BW data service, I would aggregate that first on BW side (that's more performant)