- To calculate without referring dimensions present in the view, you can use Fixed level of detail calculations.
- Syntax:{ Fixed [Dimension field]: Agg_function([Measure Field]) }
- Example: {Fixed [Category]: SUM([Sales])}
- % of Total= SUM([Sales])/SUM({Fixed [Category]: SUM([Sales])})
