How to report on Parent Item of Cascading Select Field

[Janet Whyde]

Our users have requested the ability to create dashboards that reference only the parent item value in a cascading select. As it stands, the dashboard always concatenates the parent + child item as a set of unique values. 

For example:

• Admin - Value 1
• Admin - Value 2
• Admin - Value 3
• Parent - Value 1
• Parent - Value 2

They want to be able set up a chart where they would see only two values (Admin, Parent), not 5.

CascadeOption() always returns the full string. Looking at the database, I see that these values are not stored as single strings, so there should be the ability to pull just the parent value.

Other than export to Excel and split the string, does anyone have other suggestions? 

[Planck Lee_LiJiao_]

No good answer to solve this problem?
I'm looking forward too.

My current solution is to add a one-level select list, and fill it with the parent value of the cascading select list. use this select list in dashboard.

But it's realy cost a lot of time.