Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am attempting to Create a pivot table to show available inventory.
My first dimension is 'PriceScale' my second dimension is 'secDelimit'.
For my measure, I am attempting to use an expression of =COUNT(IF(AVAILABLE = '1', SEAT_NUMBERAVAIL))
At present, my table looks as is (attached)
What is happening is that my expression is not refining to the secDelimit as is intended. The quantity of 390 is the aggregate total of all seats that fit the criteria of AVAILABLE =1.
Is my expression incorrect or does my problem lie elsewhere
You would be better off writing your expression using set analysis:
COUNT({<AVAILABLE = {'1'}>} SEAT_NUMBERAVAIL)
However, the expression isn't the issue considering the behavior you are describing. I would start by looking at your load script/table viewer and making sure all of your joins/links are performing properly and not duplicating any data.
Thank you for the response. This is my current table structure:
Availability
(Joined to PACING via 'EVENTCODE')
Contains the fields 'AVAILABLE' and 'SEAT_NUMBERAVIL'
Pacing
(Joined to MANIFEST via 'PRICESCALE')
Manifest
Contains the field 'secDELIMIT'
I do not have any Synthetic keys being created or loops
Here is the full table structure (attached)
My Pivot table is constructed as follows;
Dimensions:
ROW: PRICESCALE
COLUMN: secDELIMIT
Expression: =COUNT({<AVAILABLE = {'1'}>} SEAT_NUMBERAVAIL)
From your explanation, I can't find anything wrong with what you're doing. Can you please post an example document? It's the only way I'll be able to see if there is something else going on.
Does this work?
I'm unable to figure this out without some kind of sample data.
Without the data, I can only suggest creating a Table with dimensions PRICESCALE, secDELIMIT, SEAT_NUMBERAVAIL, and AVAILABLE. This should allow you to see if there are rows of values related to PRICESCALE and secDELIMIT fields that shouldn't be. There has to be some kind of unexpected data joining/relation that is causing values to be displayed across everything. There's no reason that the chart itself wouldn't split the values out by the dimensions.
Thank you for your help