Forum Discussion
Insert rows based on slicer value in calculated table
Hi,
I have created the following calculated table. Some sample data is below:
AccountCodeInvestmentCodeTransactionDateEndValLCYOpenValLCYTWR Open Bal LCYTWR End Bal LCYCashflowsPeriod TWR
| 35R5F5B | XNYS:SYK | 26/03/2020 12:00:00 AM | 0 | 254391.35 | 254391.35 | 1 | ||
| 35R5F5B | XNYS:SYK | 29/04/2022 12:00:00 AM | 386016 | 396880 | 396880 | 386016 | -945.2 | 0.975008062890546 |
| 35R5F5B | XNYS:SYK | 31/01/2022 12:00:00 AM | 396880 | 254391.35 | 396880 | -945.2 | 1.56383147461578 | |
| 35R5F5B | XNYS:SYK | 29/10/2021 12:00:00 AM | 254391.35 | 254391.35 | -856.8 | 1.00336803904693 | ||
| 35R5F5B | XNYS:SYK | 30/07/2021 12:00:00 AM | 254391.35 | 254391.35 | -856.8 | 1.00336803904693 | ||
| 35R5F5B | XNYS:SYK | 30/04/2021 12:00:00 AM | 254391.35 | 254391.35 | -856.8 | 1.00336803904693 | ||
| 35R5F5B | XNYS:SYK | 29/01/2021 12:00:00 AM | 254391.35 | 254391.35 | -856.8 | 1.00336803904693 | ||
| 35R5F5B | XNYS:SYK | 30/10/2020 12:00:00 AM | 254391.35 | 254391.35 | -782 | 1.00307400389203 | ||
| 35R5F5B | XNYS:SYK | 31/07/2020 12:00:00 AM | 254391.35 | 254391.35 | -782 | 1.00307400389203 | ||
| 35R5F5B | XNYS:SYK | 30/04/2020 12:00:00 AM | 254391.35 | 254391.35 | -782 | 1.00307400389203 |
I would like to add rows for each distinct InvestmentCode in the parent table (Txns) with the transactiondate set to the date selected in a slicer.
For example, if the user selected 31/07/2020 as the date on the slicer, no row would need to be added for InvestmentCode XNYS:SYK since it is already there, but would need to be added InvestmentCode ARCA:BRKB since the row is not there for that date. Wondering how to achieve this?
1 Reply
Hi khizerk ,
Why did you add that row?What kind of results do you want? Does InvestmentCode ARCA:BRKB appear in the table? Could you please provide a screenshot with your desired output?
How to Get Your Question Answered Quickly
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
