YOHZ SOFTWARE

6012 9714904 support@yohz.com https://yohzapps.yohz.com
Copyright © 2005 - 2020 Yohz Software, a division of Yohz Ventures Sdn Bhd. ALL RIGHTS RESERVED .All trademarks or registered trademarks are property of their respective owners

Data analysis made easy with analysis tables

Use analysis tables to sort, filter, group, and summarize your data whichever way YOU need. Transform this:

into this:

Grouping

You can group columns in whichever order you require. This allows you to summarize your data in many possible ways, potentially uncovering new information or patterns.

Summaries

Create summaries for any columns, or even multiple summaries for the same column using different functions. View summaries in group headers, group footers, and column footers.

Conditional highlighting

Highlight exceptional values using flexible rules and formulas.

Sorting

Sort one or more columns in ascending or descending orders, in the sequence you require. In our example, the data is first sorted by Ship Mode, then by Customer Name. The groups (Country, City, Category) are also currently sorted in ascending order.

Filtering

Each column can be filtered to display only the data you want to see. You can also apply more complex filtering rules.

Pivot tables - new dimensions revealed

Use pivot tables to analyse your data across various dimensions to gain new insights into your business.

Flexible summaries

Switch summary types just by selecting the function you want, and the pivot table will display your changes immediately.

Flexible dimensions

Create as many dimensions as you require to analyze your data. Arrange those dimentions in rows or columns to make new discoveries.

Flexible grouping

Group your dimensions’ values using values that help you uncover new trends and patterns.

Never lose track of your details

While slicing and dicing your data, you still have full access to the underlying transactional data that makes up your summaries.

Visualize using charts

For high-level summaries, you can use charts to quickly compare trends and changes. Charts will change their display depending on you change the layout of the pivot table.

Print and export

Print and export your analysis and pivot tables to multiple formats to share your insights.

Customizable layout

Arrange the analysis tables, pivot tables, and charts any which way you like.

Product video

YOHZ SOFTWARE

(6)012 9714904 support@yohz.com https://yohzapps.yohz.com
Copyright © 2005 - 2020 Yohz Software, a division of Yohz Ventures Sdn Bhd. ALL RIGHTS RESERVED .All trademarks or registered trademarks are property of their respective owners

Data analysis made easy with

analysis tables

Use analysis tables to sort, filter, group, and summarize your

data whichever way YOU need. See how you can transform

this:

into this:

Grouping

You can group columns in whichever order you require. This allows you to summarize your data in many possible ways, potentially uncovering new information or patterns.

Summaries

Create summaries for any columns, or even multiple summaries for the same column using different functions. View summaries in group headers, group footers, and column footers.

Conditional highlighting

Highlight exceptional values using flexible rules and formulas.

Sorting

Sort one or more columns in ascending or descending orders, in the sequence you require. In our example, the data is first sorted by Ship Mode, then by Customer Name. The groups (Country, City, Category) are also currently sorted in ascending order.

Filtering

Each column can be filtered to display only the data you want to see. You can also apply more complex filtering rules.

Pivot tables - new dimensions

revealed

Use pivot tables to analyse your data across various

dimensions to gain new insights into your business.

Flexible summaries

Switch summary types just by selecting the function you want, and the pivot table will display your changes immediately.

Flexible dimensions

Create as many dimensions as you require to analyze your data. Arrange those dimentions in rows or columns to make new discoveries.

Flexible grouping

Group your dimensions’ values using values that help you

uncover new trends and patterns.

Never lose track of your details

While slicing and dicing your data, you still have full access to the underlying transactional data that makes up your summaries.

Visualize using charts

For high-level summaries, you can use charts to quickly compare trends and changes. Charts will change their display depending on you change the layout of the pivot table.

Print and export

Print and export your analysis and pivot tables to multiple

formats to share your insights.

Flexible views

Arrange the analysis tables, pivot tables, and charts in the

best possible way for you to analyse your data.

Product video