Hi Hi,
I would like to create an analytical model inside the data sphere product.
I have three measures, lets say Gross Sales, Net Sales, Tax.
there is a logic between these measures. meaning, Gross Sales minus (-) the Tax = Net Sales.
so, the idea is to generate a model with one Level based measure. or a Hierarchy level. where I show the Gross Sales as the primary measure and the other two should be “sons” measures inside of it.
when I open the Gross Sales, I get the to other measures. that sum up to it. and I will see the NetSales and the Tax as two measures inside the Gross Sales.
similar to a financial report. where one measure is the some of all other measures and it is built as a Tree, or a Hierarchy of measures.
sorry in advance if this is a newbie question, but would love any assistance in this kind of design in the DataSphere product.