topic Re: Adding 2 dimensions under one heading filter pane in App Development

Adding 2 dimensions under one heading filter pane

Diinkant — Fri, 15 Nov 2024 21:54:00 GMT

Hi,

Is it possible to have 2 dimensions fall off 1 heading in a filter pane. See example below.

Customer code has a list of customers, then created dates has a list of dates. I am trying to get Loyalty and Walk In to fall under 1 heading. I.e., Customer (header), then have Loyalty or Walk In trickle under it.

The loyalty and walk in dimensions are created based on an if statement so that is why they are solo from each other.

Let me know if this is possible please.

Thanks

Re: Adding 2 dimensions under one heading filter pane

Diinkant — Fri, 14 Apr 2023 00:16:06 GMT

I have tried to create a new dimension as a drill down under master items, but that doesn't seem to pick up both dimensions. Only the first 1 from the field list.

Re: Adding 2 dimensions under one heading filter pane

Diinkant — Fri, 14 Apr 2023 04:06:19 GMT

Figured it out by using an if statement within the SQL query (in the dataload editor), so that the results are based under 1 dimension instead of 2 different dimensions.