Straight Table Set Analysis

Anonymous — Wed, 20 Dec 2017 23:10:10 GMT

Hello Community,

is it possible to get a value from a dimension within a straight table to be used in the set analysis of the measure that corresponds to it?

IE:

The Measure is sum({<YEAR = {2017},BRAND1={'b1'}>}NUMBER_OF_REGISTRATIONS)

So the G/L measure would be for each line:

Line 1: sum({<YEAR = {2017},BRAND1={'b1'}, Sales Area Code= {260}>}NUMBER_OF_REGISTRATIONS)

Line 2: sum({<YEAR = {2017},BRAND1={'b1'}, Sales Area Code= {310}>}NUMBER_OF_REGISTRATIONS)

etc....

This is part of a larger calculation, though i need only this part to be filtered down by the specific Sales Area Code.

Thoughts?

Re: Straight Table Set Analysis

sunny_talwar — Wed, 20 Dec 2017 23:13:32 GMT

If you have Sales Area Code as a dimension, doesn't it already showing the value associated with the Sales Area Code it belongs to... I wonder why would you need set analysis for something like this?

topic Straight Table Set Analysis in App Development

Straight Table Set Analysis

Re: Straight Table Set Analysis