workspace: add in a filter in dimensions | Community
Skip to main content
S
shanew76509017
November 19, 2018
Solved

workspace: add in a filter in dimensions

  • November 19, 2018
  • 3 replies
  • 2552 views

Is there an easy way to add in a new filter in the freeform table so I filter the value by containing certain keywords?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Urs_Boller

the filter should appear as soon as you move the mouse cursor over the dimension title (move over "Local var 6") and a filter icon should appear bext to the title.

be aware that filtering this way does not affect the total in the column heads. if you want the total of only selected rows, use option as roshanc44331495​ decribed above.

another way to filter and get total of selecter rows: select the desired row items (CTRL + click) then right-click to "show only selected".

3 replies

Roshanchauhan
Roshanchauhan
Level 3
November 20, 2018

Below I took page filter example:

Click the > arrow

Find the Pages you want to analyze:

Drag the first one into your table. After you find the next Page, drag the value onto the column header of your table:

This way, I'm able to focus on only the 3 Pages I want to analyze in my table, without having to worry about applying filters:

If you're curious about dimension item searching, here's a video to help you along your way:

Improvements to Dimension Item Search in Analysis Workspace - YouTube

Thanks!

Urs_Boller
Community Advisor
Urs_BollerCommunity AdvisorAccepted solution
Community Advisor
November 20, 2018

the filter should appear as soon as you move the mouse cursor over the dimension title (move over "Local var 6") and a filter icon should appear bext to the title.

be aware that filtering this way does not affect the total in the column heads. if you want the total of only selected rows, use option as roshanc44331495​ decribed above.

another way to filter and get total of selecter rows: select the desired row items (CTRL + click) then right-click to "show only selected".

S
shanew76509017Author
November 23, 2018

Thanks, very surprised that Adobe did not put it to an obvious location.

Terms & ConditionsAccessibility statement

Loading footer...