nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to create filter in Multiple axis rows and columns at the same time

143kishornaidu

I need the user to be able to filter the combos in the rows. For instance, when they select combo 1, the time dimension in the column should display with non-zero values corresponding to combo 1.

Accepted answers

Sampriti.Anand

@143kishornaidu it is still possible to achieve the result. Refer to the below screenshots

All comments

Dikshant

You need to pivot Combo list and Time both to rows. Does this view works for you ?

	Combo 1		Week 1


	Combo 1		Week 2

	Combo 2		Week 1

	Combo 3		Week 1

	Combo 3		Week 2

	Combo 3		Week 3

143kishornaidu

user needes week in column and combo 1 in rows onluy

Dikshant

So if Combo 2 has Week 3 but Combo 1 does not have Week 3, still it will show Week 3. Is it fine?

143kishornaidu

no i user want to see only those weeks only which has value for that combo

Dikshant

It's not possible with the time in columns and combo list in rows. It's possible when both the lists are in rows or in columns

seymatas1

You can create the impression of selecting rows from the same grid by placing the modules side by side on UX pages.

UX Page:

Modules:

Does this work?

Sampriti.Anand

Hi @143kishornaidu

You can keep the Combo's list in the Page selector as you want them to be a selector and create an additional line for filter in the module which drives the condition for making columns visible as required. Refer below screenshots:

Thanks!!

143kishornaidu

BUt the combo having multiple combinations.

eg: Dim1IDim2IDim3IDim4

User wants a line item filter. Also, user is filtering the Dim 1 and Dim2 In Line item filter

seymatas1

You can have the other dimensions as page selectors.

Sampriti.Anand

@143kishornaidu it is still possible to achieve the result. Refer to the below screenshots

JosephStanton

@Slice Master You can drag a field into the “Filters” area of the PivotTable Field List to create an overall filter that applies to the entire pivot table.

Quick Links

Can you help?

Unanswered questions

Question certificat
bonjour, le certificat de notre ANAPLAN arrive à expiration le 12/06/2026. Est ce vous (ANAPLAN ) qui nous fournissez un nouveau certificat ? Merci Jean-François VENISSE M +33 6 34 16 34 22 jean-francois.venisse@abeille-assurances.fr 80 Avenue de l’Europe, 92270 Bois-Colombes
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
An Update on Anaplan Audit Log Reporting: A No-Code Approach
A while back, I shared a pattern for extracting and reporting on Anaplan audit data using a Python project hosted on GitHub. I wrote that during my time on the Operational Excellence Group (OEG) at Anaplan. The Python solution still works, and plenty of teams are running it today. The problem it solves hasn't changed:…