Dynamic Header Selection

[Nikhil2725]

Hi Team,

I have 2 Filters in the App. 1 for selecting year and another for selection Product type(PH3,PH6 and PH9).

I have the below table which i'm showing in 3 different table.

PH3 Data
PH3	PH3_desc	Total Quantity	Sales T/O	Div_desc
2J1	Armaturen	127766	432843	Building Technology
127	FLEXIBLES	8145	92262	FLEX
154	WAGA-PM	566	75119	WAGA
201	PVC-UFitt.In-H.Prod.	1647730	1046367	Techno Plast
202	PVC-UValve In-H. Pr.	158463	616212	Techno Plast
PH9 Data
PH9	PH9_desc	Total Quantity	Sales T/O	Div_desc
2J1J54950	Dummy CRE/DEB PF J54	127766	432843	Building Technology
127140010	Coupling short, stee	1116	17710	FLEX
127140011	Coupling short, stee	275	5081	FLEX
127140030	Coupling short, stee	165	2260	FLEX
PH6 Data
PH6	PH6_desc	Total Quantity	Sales T/O	Div_desc
2J1J54	Regulierarmaturen	127766	432843	Building Technology
127140	PRIMOFIT end load	8145	92262	FLEX
154323	Couplings standard	542	73957	WAGA
154507	WAGA GRIP	24	1162	WAGA
201950	Solv.cement fitt.me.	1402981	874874	Techno Plast

My question is like, when I select PH9 in the filter can i get the dynamic header changed and can get the details of only PH9 details.?

Kindly help  me in this.

[Anil_Babu_Samineni]

Create the flag for each of the table and use that as filter. So it will filter based on selection of data.

[hansvillo]

Hi,

You can change the header with the following statement:

=if(GetSelectedCount(SELECTION) = 0, 'Table normal ', 'Table of selected Selection')

When you make a selection, the title changes.

🙂

[Nikhil2725]

Hi Anil,

can you brief how to create the Flag for the table?

[Anil_Babu_Samineni]

Like this, I meant

Load PH3, PH3_desc, [Total Quantity], [Sales T/O], Div_desc, 'PH3' as Flag From <PH3 Table>

[Nikhil2725]

can u brief with this with an simple example?