1. Make a copy of the dish consumption cube and rename it;
2. Add the Ratefield into the cube: Dimensions – External Dimensions. Enter your username. This field will show the VAT rate used in reports, for instance, 0, 10, or 18.

Fig. 1

1. Add the VAT field – Amount. Dimensions – Factual Enter your username.

Fig. 2

1. Add the Amount without VAT field. The field will be added to the Calculated Fields group. Add the calculated field by clicking the right button of the mouse. Dimensions – Factual Enter your username.

Fig. 3

1. The following settings should be activated for the Amount without VAT field in the calculated fields: tick Before Grouping. Calculation type – Calculation Based on Formula. Enter the calculation formula in the Formula field: Paid -VAT Amount.

Fig. 4

1. Recalculate the new cube. Click the cube using the right button of the mouse. Actions – Recalculate.

Fig. 5

1. The following data will be available for you in the new cube: