0

Jet Data Manager - Calculated Measure by multiple percentages

I have a measure as "Budget Amount" in the transaction table and this can be analyze by Project ID. Then I have another data sets with multiple percentages such as 

Geographical

Asia : 30%, Europe 40%, Americas 30% 

Gender:

Male 49%, Female : 51%

Theme  

Forest 20%, Species 30%, Marine : 50%

and more. All percentages are by project ID too.

I want to create calculated measure (or something else) to get budget amount by project ID and by each percentage (by theme or gender or by Geographical) without breaking transaction table into details at the data warehouse database. 

0 comments

Please sign in to leave a comment.