Possible to Sort / Filter table?

[H_L]

Hi there,

We created a table as following example, sorts Product Name by Order in the last day.

Just wanted to ask:

Is there a way to create (or filter) a table with number of Order greater than X that have Purchase% lower than Y (of the latest day)?

E.g. a table shows all Product Name those Order more than 20 AND Purchase% lower than 40% in 17-OCT (last day, latest day). - Keep all the past 7 days data.

Thanks in advance.

H

[yuhuisg]

It's not easily done in Analysis Workspace. Unfortunately, in there, tables can only be filtered by dimensional values.

Segments won't work in your case because segments are applied on the individual hits of data. In your case, though, you want a total number of Orders or an aggregate percentage of Purchase% over a range of hits.

Your best bet is to build this in Excel.

[H_L]

Thanks for reply, then we need to find a way to build the dynamic table, since the ideal table is: scheduled and delivered on daily basis, which means, everyday, build a table (report) with the last 7 day's data, sort by Order and include those Order > 20 and/or Purchase% < 40% in the last date.

Maybe we need to schedule the raw data, and ask DBA's support to proceed in another BI tool.

Have a good day.

[yuhuisg · Accepted solution]

If you have permission to use ReportBuilder (and are using a Windows computer with Excel), then you can build and schedule your reports in Excel using ReportBuilder to get the data for you. Then you don't need to go down the DB/BI tool path.

[H_L]

Hi yuhuisg,

yes I am using report builder and scheduling the report, I am still thinking how to make it...could you provide some threads or ideas about the "filter" function can be refreshed on daily basis?

[yuhuisg]

I was thinking of Excel's own Filter function.