Multiple Values, same date

[evansabres]

I have a field, [Game Date] for which there is the potential to have several data points associated to one particular [Game Date].

Example,

[Game Date] = 10/5/2017

totalsale = $171

qtysold = 2

however, there is also

[Game Date] = 10/5/2017

totalsale = $126

qtysold = 2

How do I show both instances of this [Game Date] as there are two separate transactions.

I am showing this in a table and used the expression: =FirstSortedValue(DISTINCT TOTALSALE, -[Game Date]), which only returns the first value. I am looking to return both (or however many there are) values

[Anonymous]

Hello,

Try to use TOTALSALE and qtysold as dimension on your table, and Game Date as expression, like this:

=[Game Date]

[evansabres]

This did not function correctly for me

[Anonymous]

With this data ...

Data:

Load * Inline

[Game Date, TOTALSALE, qtysold

10/5/2017, 171,      2

10/5/2017, 126,      2

10/5/2017, 126,      3

];

... and a table configured like I said, it gives me this result:

Isn't it what you trying to achieve?

[evansabres]

That is what I am attempting to achieve. However, when make my dimension of Game Date an expression and totalsale and qty the dimensions, the results are not as expected. There should be 39 results, and there are only a dozen or so.

[Anonymous]

Ok!

Try to add another field to your table in script, in this case the row number:

Data:

Load *,

          RowNo() As RowNumber

Inline

[Game Date, TOTALSALE, qtysold

10/5/2017, 171,      2

10/5/2017, 126,      2

10/5/2017, 126,      3

13/5/2017, 126,      3

13/5/2017, 126,      3

];

And build your table like this:

Dimension: RowNumber

Expressions:

=[Game Date]

=TOTALSALE

=qtysold

On "presentation" tab, check "hide column" for the "RowNumber" Column.

Result:

[MarcoWedel]

If you want to show those three fields as is, you might just use a table box instead.

[evansabres]

Is it possible to do expressions in a table box? In the straight table that I was trying to create, I had expressions that were more than just the field name. Is this possible in a table box?

[MarcoWedel]

No, table boxes don't have the option to create expressions.

[qliksus · Accepted solution]

Why don't you use a straight table with TOTALSALE as dimension and expression  and hide the expression field