meta data for this page
Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
en:v8_0_0:designer:menus:accueil:nouvellerequete:tableaucroise [2020/07/23 11:09] sylvainair [Treemap] |
en:v8_0_0:designer:menus:accueil:nouvellerequete:tableaucroise [2020/09/14 15:58] (current) sylvainair [Save and recall a pivot table/chart] |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== Pivot Table ====== | ====== Pivot Table ====== | ||
- | |||
{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-102937.png?nolink&500}} | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-102937.png?nolink&500}} | ||
- | |||
===== Usage ===== | ===== Usage ===== | ||
Line 10: | Line 8: | ||
{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-102832.png?nolink}} | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-102832.png?nolink}} | ||
+ | |||
+ | ===== Types of table/chart ===== | ||
+ | A first drop-down list lets you choose the type of table/chart you want to display. | ||
+ | |||
+ | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-113946.png?nolink}} | ||
==== Table ==== | ==== Table ==== | ||
Line 29: | Line 32: | ||
==== Area chart ==== | ==== Area chart ==== | ||
{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-104720.png?nolink&650}} | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-104720.png?nolink&650}} | ||
- | ==== Scatter chart ==== | ||
==== Treemap ==== | ==== Treemap ==== | ||
Line 41: | Line 43: | ||
{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-110517.png?nolink}} | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-110517.png?nolink}} | ||
- | Depending on the type of aggregation chosen, zero, one or two fields can be specified as parameters. | + | Depending on the type of aggregation chosen, zero, one or two fields can be specified as parameters.\\ |
{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-110911.png?nolink}}\\ | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-110911.png?nolink}}\\ | ||
{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-110803.png?nolink}}\\ | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-110803.png?nolink}}\\ | ||
Line 52: | Line 54: | ||
+ | ==== Page fields ==== | ||
+ | This is the area for fields you don't want to see the details of.\\ | ||
+ | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-112310.png?nolink}} | ||
+ | |||
+ | ==== Columns fields ==== | ||
+ | This is the area for the fields whose details you want to see in the columns.\\ | ||
+ | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-112444.png?nolink}} | ||
+ | |||
+ | ==== Columns fields ==== | ||
+ | This is the area for the fields whose details you want to see in the lines.\\ | ||
+ | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-112652.png?nolink}} | ||
+ | |||
+ | |||
+ | ===== Save and recall a pivot table/chart ===== | ||
+ | At the top left of the screen is the ''Save Current Format'' button. | ||
+ | |||
+ | You just have to give it a name and define whether it is public or private. | ||
+ | |||
+ | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-112856.png?nolink}} | ||
+ | |||
+ | When a pivot table format exists, a drop-down list allows you to recall a format. | ||
+ | |||
+ | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-113202.png?nolink}} | ||
+ | |||
+ | The edit button allows you to change name and switch the public/private status of the format. | ||
+ | |||
+ | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-113518.png?nolink}} | ||
+ | The last button ({{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200629-165011.png?nolink}}) lets you to delete a format. |