Page History

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

...

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

...

1. Axis – Fact. Specify the user name.
   Image Added
2. Add the Amount without VAT field. The field will be added to is created in the Calculated Fields group. Add the calculated field by clicking the right button of the mouse. Dimensions – Factual Enter your username.

Fig. 3

1. Right-click and choose Create User Fact. Axis – Fact. Specify the username.
   Image Added
2. Make the following settings for Amount without VAT The following settings should be activated for the Amount without VAT field in the calculated fields: tick check the Before Grouping. Calculation type – Calculation Based on Formulagrouping box. Select Calculate Formula in Calculation Type line. Enter the calculation formula in the Formula fieldline: Paid Sum -Tax 'VAT'- Amount.
   

...

1. Image Added
2. Recalculate the new cube. Click Right-click the cube using the right button of the mouse. Select Actions – — Recalculate.
   

...

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