Dátové pole

Dvojitým kliknutím na tlačidlo v časti Dátové pole vyvoláte dialógové okno Dátové pole.

Medzisúčty

Specify the subtotals that you want to calculate.

Žiadne

Does not calculate subtotals.

Automaticky

Automatically calculates subtotals.

Definované používateľom

Select this option, and then click the type of subtotal that you want to calculate in the list.

Funkcia

Click the type of subtotal that you want to calculate. This option is only available if the User-defined option is selected.

Show items without data

Zahŕňa prázdne stĺpce a riadky do tabuľky s výsledkami.

Názov:

Lists the name of the selected data field.

Viac

Expands or reduces the dialog. The More button is visible for data fields only.

Možnosti

Opens the Data Field Options dialog. The Options button is visible for column, row, or page fields only.

If the dialog is expanded by the More button, the following items are added to the dialog:

Zobrazená hodnota

For each data field, you can select the type of display. For some types you can select additional information for a base field and a base item.

Typ

Vyberte typ výpočtu zobrazenej hodnoty pre dátové pole.

Typ

Zobrazená hodnota

Normálne

Results are shown unchanged

Rozdiel od

From each result, its reference value (see below) is subtracted, and the difference is shown. Totals outside of the base field are shown as empty results.

Named item

If a base item name is specified, the reference value for a combination of field items is the result where the item in the base field is replaced by the specified base item.

Previous item or Next item

If "previous item" or "next item" is specified as the base item, the reference value is the result for the next visible member of the base field, in the base field's sort order.

% Of

Each result is divided by its reference value. The reference value is determined in the same way as for "Difference from". Totals outside of the base field are shown as empty results.

% rozdiel od

From each result, its reference value is subtracted, and the difference is divided by the reference value. The reference value is determined in the same way as for "Difference from". Totals outside of the base field are shown as empty results.

Celkom beží v

Each result is added to the sum of the results for preceding items in the base field, in the base field's sort order, and the total sum is shown.

Results are always summed, even if a different summary function was used to get each result.

% riadkov

Each result is divided by the total result for its row in the pivot table. If there are several data fields, the total for the result's data field is used. If there are subtotals with manually selected summary functions, the total with the data field's summary function is still used.

% stĺpcov

Same as "% of row", but the total for the result's column is used.

% celkovo

Same as "% of row", but the grand total for the result's data field is used.

Index

The row and column totals and the grand total, following the same rules as above, are used to calculate the following expression:

( original result * grand total ) / ( row total * column total )


Základné pole

Vyberte pole, z ktorého sa príslušná hodnota vezme ako základ pre výpočet.

Base item

Vyberte položku základného poľa, z ktorej sa príslušná hodnota vezme ako základ pre výpočet.

Please support us!